If Statement / VLookup
 

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

If Statement / VLookup
 

Try

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



"Pb" wrote:

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

If Statement / VLookup
 

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

"daddylonglegs" wrote:

Try

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



"Pb" wrote:

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