MS Excel通配符查找 [英] MS Excel wildcard lookup
问题描述
我在Excel中具有ColA和ColB的查找表:
I have a lookup table in Excel with ColA and ColB :
ColA ColB ColC
va 1 value1
ColC是实际值表
我需要使用lookup_value ="value1"进行通配符查找 我需要执行一个操作,如果ColC的值与ColA中的字符匹配,那么它应该返回我的ColB值,即1
I need to do a wildcard lookup with lookup_value = "value1" I need to perform an operation that if the value of ColC matches the characters in ColA then it should return me ColB value, i.e. 1
我想在查找功能中使用通配符以实现此结果. 任何帮助将不胜感激! 谢谢
I want to use wildcards in the lookup function to achieve this result. Any help will be appreciated! Thanks
推荐答案
您可以在VLOOKUP中使用通配符.您必须重新排列表格,以使查找列为第一列,但除此之外,它应该可以工作.我把:
You can use wildcards with VLOOKUP. You'll have to rearrange your table so that the lookup column is the first column, but other than that it should work. I put:
abc 1
def 2
ghi 3
jkl 4
进入名为表"的范围
然后:
g*
g?i
?kl
进入F2:F4
现在,在G2:G4中,我输入以下公式:
Now, in G2:G4, I put this formula:
= VLOOKUP(F2,table,2,FALSE)
=VLOOKUP(F2,table,2,FALSE)
,它正确地在单元格G2&中找到3. G3和G4单元格中的4.
and it correctly found 3 in cells G2 & G3, and 4 in cell G4.
星号表示零个或多个字符;问号恰好表示一个字符.
The asterisk means zero or more characters; the question mark means exactly one character.
这篇关于MS Excel通配符查找的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!