VLOOKUP issue

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

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

Change the ranges as necessary to fit your data.


"nfbelo" <[email protected]> wrote in message
news:[email protected]...
> 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