VLOOKUP #N/A problem.

[uveenhacked]

i have a list of items,

column A, as product name. Column B as Category

I use Vlookup to find which category a product belongs, my problem is it returns a #N/A if it can't find that item (i know it will)... my problem is, is there anyway i can do to just return "NOT FOUND" if that product is not in the list?

Thanks in Advance...

 

[PaddyD]

see:

http://www.mrexcel.com/board2/viewtopic.php?t=62102