Adding two columns with vlookup
 

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

Adding two columns with vlookup
 

=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)

"JR" wrote in message
...
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

Adding two columns with vlookup
 

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


"JR" wrote:

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