the easiest way is =
if(iserror(VLOOKUP(1,$X$10:$Z$17,3,FALSE)),"",(VLO OKUP(1,$X$10:$Z$17,3,FALSE))

This way a "blank" is displayed

"Babs in Ohio" wrote in message
...
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