This is the closest I got with a formula:
=INDEX($B$2:$B$10,MATCH("*"&SUBSTITUTE(A16," ","*")&"*",SUBSTITUTE($A$2:$A$10," ",""),0))
copied down.
This is the closest I got with a formula:
=INDEX($B$2:$B$10,MATCH("*"&SUBSTITUTE(A16," ","*")&"*",SUBSTITUTE($A$2:$A$10," ",""),0))
copied down.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks