可以在vlookup中使用通配符吗? [英] can you use wildcards with vlookup?

问题描述

我想进行vlookup，但我想使其与单元格的SUBSET匹配.这可能吗?

i would like to do a vlookup, but i would like it to match the SUBSET of a cell. is this possible?

例如，如果我正在寻找"alex is smart"并且单元格具有"alex is smart blah blah""，我希望它在alex is smart上匹配

for example, if i am looking for "alex is smart" and the cell has "alex is smart blah blah", i want it to match on alex is smart

这可能吗?

推荐答案

您可以在查找值参数中使用通配符.如果单元格A1包含文本"alex is smart"，则可以使用:

You can use wildcards in the lookup value argument. If cell A1 contains the text "alex is smart" you can use:

=VLOOKUP("*"& A1 &"*",A2:B3,2,FALSE)

您还可以将查找值硬编码为:

You can also hard-code the lookup value like:

=VLOOKUP("*alex is smart*",A2:B3,2,FALSE)

这篇关于可以在vlookup中使用通配符吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！