Vlookup

T

Tixpack

When using vlookup function on a long list of data, how do I replace a #N/A
result with the number 0?

I am using the vlookup function on a cumulative list of data that is adding
up annual results. Each year new names are added to the list and some do not
come back (i.e. participate in 2006 but not in 2007). But have a cumulative
list contains all participants. I want to have a 0 when someone does not a
result for a year, not a #N/A - I can't sum up #N/A's.

Please help!
 
T

T. Valko

You can ignore #N/A in a sum formula like this:

=SUMIF(A:A,"<1E100")

However, it's probably better to get rid of the #N/A altogether:

=IF(ISNA(VLOOKUP(..........)),0,VLOOKUP(..........))
 

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

Top