If Statement / VLookup

[Pb]

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

 

[daddylonglegs]

Try

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

 

[Pb]

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!!