On 17 . ., 20:20, 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


Try

=If(Countif($X$10:$X$17,1)0,Vlookup(1,$X$10:$Z$17 ,3,FALSE),"")

Enter