VLookup results in #n/a - write a formula that sums

  • Thread starter Thread starter Jean
  • Start date Start date
J

Jean

The results of a Vlookup will be #N/A in cells that do not
find a match. I saw someone write a forumula that would
sum the column while overlooking the #N/A cells but I
don't remember how it was written. Any help will be
greatly appreciated.


Thank you
 
You could have a formula like:

=if(isna(lookup(a,range,1)),0,lookup(a,range,1))

It basically states that if you would get a #N/A result, then show 0, which
would not affect a SUM.

André
 
Back
Top