Use ISNA:

so

=VLOOKUP(E1,$A$10:$D$13,3,0)

becomes

=IF(ISNA(VLOOKUP(E1,$A$10:$D$13,3,0)),"",VLOOKUP(E 1,$A$10:$D$13,3,0))

Hope this Helps
Rowan

"Patrick" wrote:

For the cells that return no value #NA is shown in the cell. I would like
these cells simply to be blak. How is this done? Please HELP.

Thanks