Thread
:
Make #N/A blank if no value is returned
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Babs in Ohio
external usenet poster
Posts: 6
Make #N/A blank if no value is returned
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
Reply With Quote
Babs in Ohio
View Public Profile
Find all posts by Babs in Ohio