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
|