If Statement / VLookup

G

Guest

I have the following where A23 is a user entered field and when it is blank,
it returns the #N/A. I don't understand the required "IF" statement to return
blank instead of #N/A. (The lookup works correctly if A23 value is entered).

=VLOOKUP(A23,Product!$A$1:$C$7,2)

Thanks,

Peter
 
G

Guest

DLL,

Thanks alot. It appears to be it. I kept beating myself up, trying to add
the "IF" to the end of the vlookup!!!

Have a Great Weekend!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP help (possible format issue) 6
mutliple criteria vlookups 5
cell value based on null/not null in another cell 1
HOW DO I ... (ASAP PLEASE!!!) 2
Vlookup and If statement help 1
If, then Formulas 1
Help With VLOOKUP 2
How can I have a false Vlookup give a blank instead of #N/A? 2

Top