Try this, in D1 copy down,
=IFERROR(LOOKUP(9E300,SEARCH(SUBSTITUTE(B$1:B$3," ","*"),A1),C$1:C$3)&" "&MID(A1,FIND("[",A1),250),"")
Try this, in D1 copy down,
=IFERROR(LOOKUP(9E300,SEARCH(SUBSTITUTE(B$1:B$3," ","*"),A1),C$1:C$3)&" "&MID(A1,FIND("[",A1),250),"")
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks