uveenhacked
New Member
- Joined
- Nov 18, 2005
- Messages
- 28
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...
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...