Make #N/A blank if no value is returned
Babs
One way is:
=if(VLOOKUP(1,$X$10:$Z$17,1)=1,=VLOOKUP(1,$X$10:$Z $17,3) ,"")
Good luck.
Ken
Norfolk, Va
On Jul 17, 9:20 am, 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
|