Adding two columns with vlookup

J

JR

Can someone give me an example of what the formula would look like is I
wanted to use a vlookup and add together two columns?

Thanks
 
B

Bob Phillips

=INDEX(C1:C100,MATCH(1,(A1:A100=M1)*(B1:B100=N1),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
D

Duke Carey

To add the 2d & 3d columns in the lookup table:

=VLOOKUP(lookup value, table,2,false)+VLOOKUP(lookup value, table,3,false)

Might be simpler to add a column to the lookup table that sums those other
two columns, then use a single vlookup to get the sum
 
Top