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