Could any one please help to create formula for attached file data. A VBA code also helpfull.
Thank You
Ansh
Could any one please help to create formula for attached file data. A VBA code also helpfull.
Thank You
Ansh
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
Thanks for the Like
Don’t have an account yet? Register yourself now and be a part of our community!