=IFERROR(LOOKUP(2,1/COUNTIF($D2,"*"&MID($B$2:$B$8,9,FIND("-",$B$2:$B$8)-9)&"*"),C$2:C$8),"")
or try above formula inspired by "Sixthsense"
=IFERROR(LOOKUP(2,1/COUNTIF($D2,"*"&MID($B$2:$B$8,9,FIND("-",$B$2:$B$8)-9)&"*"),C$2:C$8),"")
or try above formula inspired by "Sixthsense"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks