Lookup

[bMadzima]

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

[Pete_UK]

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

[wk9128]

B2 cell formula

[bMadzima]

Thanks so much it worked.

[bMadzima]

Hi Pete

Thanks again your suggested formula eventually worked.I had to validate the data first for it work.Thanks.

Regards
Brian

[wk9128]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'.