vlookup text + number not working

Hi,

I have 2 worksheets. Need to look up B col description (contains text and numbers) in worksheet 1, and match with Col B in worksheet 2, return value from col G. If I use match partial text, it returns wrong value from col G. If I match exact description, it returns #N/A.

Please help me. Thanks.

Vinnie

If it returns #N/A, then no match was found. Check your columns for trailing spaces or other invisible characters that would prevent an exact match.

Hi,

I can't file the "attached file" icon.
Please show me. Thanks.

Vinnie

Click the "Go Advanced" button in the quick reply box below. Click the paperclip icon (to the right of the smiley and to the left of the Undo arrow).

Hi,

Here is the file. Thank you so much for your help.

Vinnie

Hi Kelshaer,

Can you please let me know why you're using _xlfn. in front of IFERROR?

Thanks very much for your help.

Vinnie

I am guessing that you have Excel 2003. IFERROR is an Excel 2007+ function. Try this:

=IF(ISERROR(VLOOKUP(B7,'NAT 52 WKS'!B:E,4,FALSE)),"NOT FOUND",VLOOKUP(B7,'NAT 52 WKS'!B:E,4,FALSE))

Hi Kelshaer,

I use your file and copy the formula down, I got #Name? Didn't get what you have there.
Please help. Thanks a lot.

Vinnie

Hi,

Thank you very much for everyone who helped me to solve my problem.

I can't find the prefix "SOLVED".

Please tell me where to find it.

Thanks again.

Vinnie