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