Please help for create formula using Isnumber, search and vlookup or index.

Hello,

Attached is your test file

Hope this will help

Or try this non-array formula

In A1, formula copied down :

=IFERROR(LOOKUP(1,SEARCH(L$1:L$4,B1),M$1:M$4),"")

Regards

@ansh2792

Thanks for the Like