=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