Remove errors

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I am using a vlookup finction, and when it doesn't find a record it
returns an N/A error. Is there any way to remove the N/A error in the
formula so I can sum the returned data? Thanks.
 
New in Excel 2007 is the IfError() function, used like so.

=IFERROR(your formula,0)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ISERROR on VLOOKUP 3
Errors encountered when using If & Vlookup formulas 2
Help With VLOOKUP 2
Use & with two formulas 2
VLOOKUP 3
How can I change an #N/A error to display other text? 1
SUM with nested VLOOKUPS - can i make it ignore N/As? 5
Sum the results of a vlookup 6

Back
Top