Dear Friends,
I tried used vlookup formula but with different lookup value, is not work.
please help to advise with formula needed.
attached file for sample.
Thank you in advance for your help
Regards,
Wie
Dear Friends,
I tried used vlookup formula but with different lookup value, is not work.
please help to advise with formula needed.
attached file for sample.
Thank you in advance for your help
Regards,
Wie
Try:
=VLOOKUP("*"&A3,Data!$A$2:$B$5,2,0)
with * mean "whatever before value of cell A3"
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks