Hi
I would to lookup for the Code description for the data at the left hand.The lookup range is Column J.Thanks.
Regards
Brian
Hi
I would to lookup for the Code description for the data at the left hand.The lookup range is Column J.Thanks.
Regards
Brian
You can use this formula in B2:
=IFERROR(VLOOKUP(A2,H:I,2,0),"")
then copy down. It will return a blank if the code is not found.
Hope this helps.
Pete
B2 cell formula
HTML Code:
Thanks so much it worked.
Hi Pete
Thanks again your suggested formula eventually worked.I had to validate the data first for it work.Thanks.
Regards
Brian
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks