Try the below array formula (Ctrl+Shift+Enter) and copy towards down
=IFERROR(INDEX($C$2:$C$8,MATCH(1,COUNTIF($D2,"*"&REPLACE(LEFT($B$2:$B$8,FIND("-",$B$2:$B$8)-1),1,8,"")&"*"),0)),"")
Try the below array formula (Ctrl+Shift+Enter) and copy towards down
=IFERROR(INDEX($C$2:$C$8,MATCH(1,COUNTIF($D2,"*"&REPLACE(LEFT($B$2:$B$8,FIND("-",$B$2:$B$8)-1),1,8,"")&"*"),0)),"")
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