how to vlookup colume with different values

[Bklynhyc]

Hi,

I would like to use vlookup or other to number and match two lists,

first is with number reference assigned

date merchant amount ref.
05/16/09 1234 500.00 1
05/17/09 1234 600.00 2

second list

merchant
1234
date amount
05/16/09 500.00

merchant
1234
date amount
05/17/09 600.00

thanks

 

[Jacob Skaria]

When you have multiple criteria use SUMPRODUCT()

=SUMPRODUCT((A1:A10=criteria1)*(B1:B10=criteria2),C1:C10)

If this post helps click Yes

 

[Bklynhyc]

I dont know how to go about formulate the formula, Please advice.

first spread sheet
ABCD
1.date merchant amount ref.
2.05/16/09 1234 500.00 1
3.05/17/09 1234 600.00 2

second spread sheet
ABCD
1.merchant
2.1234
3.date amount
4.05/16/09 500.00
5.
6.merchant
7.1234
8.date amount
9.05/17/09 600.00