Try
=LOOKUP(2^15,SEARCH($B$2:$B$12,A19),$B$2:$B$12)
Notes:
There cannot be any blanks in B2:B12
If there are multiple occurrences of values from B2:B12 within A19, it will return the one that appears last in B2:B12
Try
=LOOKUP(2^15,SEARCH($B$2:$B$12,A19),$B$2:$B$12)
Notes:
There cannot be any blanks in B2:B12
If there are multiple occurrences of values from B2:B12 within A19, it will return the one that appears last in B2:B12
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks