Hi,

I would like some help with this issue. In my worksheet I have:

A B C M1 N1
320 LIS 11040 333 LIS
320 OPO 12500
333 LIS 13000
1011 LIS 5000 Total (O1) = 13000
320 FNC 15900
1011 OPO 14000
333 OPO 12000

When I use M1 and N1 in my VLOOKUP I need O1 to give 13000, i.e, I need to
join cols A+B in a VLOOKUP to get C.
Should I use VLOOKUP, if so How?
Thanks