Formula Help - Sums&Lookups

[mkerstei]

Hi,
I am trying to create broad equations that will be used for specific ones. What I mean is, I have several named ranges for finding equations using vlookups. "A" range pulls a vlookup for 1. "B" pulls a vlookup for 2. "C" pulls 3. Etc, etc. I then created equations which looked like =A+B-C. For most of the data, this equation works but occasionally, the row for the vlookup for B is nonexistent, in other words, it is trying to find 2 when 2 does not exist. Obviously this then pulls an #N/A for "B," but this causes the whole equation to null out as #N/A. Is there any way to keep the equation the same while possible making the #N/A automatically go to 0 or something so the equation will still work if one part of it is null?

[Flintstone]

Hello mkerstei:

This should do it.

=IF(ISNA(VLOOKUP(2,A2:B10,2)),0,VLOOKUP(2,A2:B10,2))

Matt