VLOOKUP issue

[Guest]

Hi,

I hould like some help with this problem, In my worksheet I have:

A B C M1= 333
320 LIS 1000 N1= OPO
320 OPO 1200
333 LIS 1420 O1(vlookup)= 1833
1011 LIS 1500
333 OPO 1833
1011 OPO 1544

Weel I need to get 1833 in O1 after joining the info in M1 and N1.
I'm trying to use a VLOOKUP in O1 but I need to join the info of cols A and
B, and vlookup doesn't let me.
Should I use a Vlookup, if so how?
Thanks

 

[Lewis Clark]

In cell O1, try:
=SUMPRODUCT((A3:A8=M1)*(B3:B8=N1)*(C3:C8))

Change the ranges as necessary to fit your data.