UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Hiding Error Values    
 
   
faragher
post Aug 22 2003, 04:46 AM
Post#1



Posts: 416
Joined: 16-February 03
From: Devon, UK


It can be very irritating to have error values in your spreadsheet, especially where you have a sum() or similar that then picks up this error.
You can use Iserror() to avoid this. For example:
=VLOOKUP(A1,G1:H20,2,FALSE) will return a #N\A if there is no matching value. This can be trapped out with:
=IF(ISERROR(VLOOKUP(A1,G1:H20,2,FALSE)),"",VLOOKUP(A1,G1:H20,2,FALSE))
This will give you a blank cell if there is no matching value.
Have fun!
John F
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    11th December 2017 - 03:46 PM