Forum Discussion
Vlookup with '*' wildcard character
Hello Experts , Could you please help me with trick or method to use v-lookup on 'wildcard' character. e.g. 7K_*1 should return '3' using v-lookup. 7K_11 1 7K_12 2 7K_*1 3 7K_...
Hey Rajiv-
Maybe try using this formula:
=VLOOKUP(SUBSTITUTE(E3,"*","~*"),$A$3:$B$12,2,FALSE)
I've attached a sample file for reference...
Its giving '1' not '3'
try sorting the list -- the answer will be correct
this time I think it shoud be set to FALSE
HTH
- My bad for not putting question accurately. I wish to understand how do we handle '*' in v-look up function .
Sorting will surely resolve given example but it wont work if there are more than 1 wildcard entries in range . It will pick up only 1st value in that case.- maybe the site below will help you
https://exceljet.net/formula/get-nth-match-with-vlookup