VLOOKUP文本不是唯一的-Excel [英] VLOOKUP Text that is not unique - Excel

问题描述

我正在尝试vlookup(重新带回)所有肯定的产品，但是只有第一个结果会不断返回，因为vlookup停留在第一条数据上.

I am trying to vlookup (bring back) all the products that are yes, but only the first result keeps coming back because the vlookup gets stuck on the first piece of data.

我使用的数据超出以下范围，但请参见以下示例.

I am using much more data than the range below but please see below as example.

A1 = Yes B1 = Product 1
A2 = Yes B2 = Product 2
A3 = Yes C3 = Product 3

=vlookup("Yes",$A$1:$C$3,2,false)

如果我删除$符号，它会起作用，但是我只会得到重复的值.

It works if I take out the $ signs but then I just get repeat values.

我猜想这需要其他功能，但是不确定使用什么.

I am guessing this needs a different function but am unsure what to use.

谢谢

伊恩

推荐答案

检查

Check this link and understand how that formula works. In your example, put this formula into cell D2 and press CTRL+SHIFT+ENTER and fill down using mouse:

=IFERROR(INDEX($B$1:$B$12, MATCH(0,IF("yes"=$A$1:$A$12,COUNTIF($D$1:D1, $B$1:$B$12),""), 0)),"")

这篇关于VLOOKUP文本不是唯一的-Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！