You've probably already had your answer to this, as Google Groups
hasn't updated since about 2pm yesterday, but in case you haven't then
try this:

=IF(ISNA(VLOOKUP(1,$X$10:$Z$17,3,FALSE)),"",VLOOKU P(1,$X$10:$Z
$17,3,FALSE))

Hope this helps.

Pete

On Jul 17, 2:20 pm, Babs in Ohio
wrote:
Using VLOOKUP some of my values are #N/A. The formula I am using is:

=VLOOKUP(1,$X$10:$Z$17,3,FALSE)

If the value returned is #N/A how can I make it display blank or null?
--
Babs