When you have multiple criteria use SUMPRODUCT()

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

If this post helps click Yes
---------------
Jacob Skaria


"Bklynhyc" wrote:

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