=IFERROR(INDEX($F$4:$F$15,MATCH(TRUE,INDEX((COUNTIF($A2,"*"&$E$4:$E$15&"*")<>0),0),0)),".")
Try this formula in "C2" and copy towards down
=IFERROR(INDEX($F$4:$F$15,MATCH(TRUE,INDEX((COUNTIF($A2,"*"&$E$4:$E$15&"*")<>0),0),0)),".")
Try this formula in "C2" and copy towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks