I am using vlookup to search an incomplete list so as to return a corresponding value.
If the entry I am searching for is not there, Excel returns #N/A.
I would like to write a formula that goes something like if(vlookup search is successful, return value, "not found").
I've tried IsErr, but this returns an error if you pass it a non-error value, so I can't then return the successful value.
Hopefully the attachment will make more sense! When looking up the value 3 in the database, I would like to be able to say "not found", or use another function.
Thanks in advance for your help,