Forum Discussion
URGENT need help - partial match to get answer excel
=VLOOKUP("*"&LEFT(B2,15)&"*",CHOOSE({1,2},Legend!$C$2:$C$20,Legend!$B$2:$B$20),2,FALSE)
Do you want to return the contribution level? This could be possible with above formula. Enter the formula as arrayformula with ctrl+shift+enter if you don't work with Office365 or 2021.
hi, i m a excel learner and curious to know & discuss, i wonder why you used "*"& in lookup argument of vlookup rather than only left function? i tried with only left function & didn't recieve any results.
i would appreciate if you help me out of it.
If you enter "*"&LEFT(B2,14)&"*" as search value VLOOKUP performs a partial match. For example the search value "Senior manager" would be found in the search array within the strings "Senior manager assistant" and "Executive Senior manager director".
Search value LEFT(B2,14) would mean that VLOOKUP performs an exact match. There would only be a search result if e.g. search value is "Senior manager" and the string "Senior manager" is found in the search array.
- ooh that way, now i get it, thank you quadruple.