VLOOKUP

P

Patrick

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
 
R

Rowan

Use ISNA:

so

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

becomes

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

Hope this Helps
Rowan
 
P

Patrick

Perfect, thanks Rowan!

Rowan said:
Use ISNA:

so

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

becomes

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

Hope this Helps
Rowan
Click to expand...
 
Top