I found this formula online which returns a blank cell if the VLOOKUP doesn't find anything in the 3rd column instead of ZERO.

<code>

=IF(LEN(VLOOKUP(A1,Sheet1!$1:$1048576,3,FALSE))=0,"",VLOOKUP(A1,Sheet1!$1:$1048576,3,FALSE))

</code>

The formula works great but need to add an additional argument. I would like to add

<code>

IF A1 is greater than blank then VLOOKUP(A1,Sheet1!$1:$1048576,3,FALSE

</code>

Can anyone help?