Hi

Aprreciate someone can help me.

I got this 2 worksheet, SPF and ABC. ABC is the master table.

For example: SPF, 1234 and some other inforamtion in the columns. ABC
(Master table & some other information in the columns) is 1234A (with a
alphabet). How to return the result 1234A to SPF worksheet.

I try using vlookup, match and the result is #N/A. I need to find the 1234A.

Thanks in advance.