Put the following formula in cell B3 and confirm it with ctrl+shift+enter:
=INDEX($B$6:$B$7,MATCH(1,FIND($A$6:$A$7,A3)^0,0))
If you need this formula to NOT be case-sensitive, then replace "FIND" with "SEARCH".
Put the following formula in cell B3 and confirm it with ctrl+shift+enter:
=INDEX($B$6:$B$7,MATCH(1,FIND($A$6:$A$7,A3)^0,0))
If you need this formula to NOT be case-sensitive, then replace "FIND" with "SEARCH".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks