vlookup wildcard logic %

  • Thread starter Thread starter eringreene
  • Start date Start date
E

eringreene

can you use %wildcard logic in v-lookup?

so if i have a lookup formula with wildcard logic in one of the cells
will v-lookup work
 
Hi
you may try the following array formula to search for *ad* in column A
and return the value from column B. Enter this formula with
CTRL+SHIFT+ENTER
=INDEX(B1:B100,MATCH(TRUE,ISNUMBER(FIND("ad",A1:A100)),0))
 
Back
Top