Thread: Make #N/A blank if no value is returned
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Make #N/A blank if no value is returned
And if you're using xl2007, take a look at =iferror() in Excel's help.

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

--

Dave Peterson
Reply With QuoteReply With Quote