So this is what i got , any suggestion?

=INDEX($J$2:$J$9,MATCH(1,INDEX(($G$2:$G$9=A2)*($H$ 2:$H$9=B2)*($I$2:$I$9=C2),,),0),1)

first list with reference.
GHIJ
merchant date amt ref.
1234 06/01/09 500.00 1
1233 06/02/09 400.00 2


second list w/o reference

abcd
merchant date amt ref.
1234 06/01/09 500.00 1
1233 06/02/09 100.00 #N/A
1233 06/02/09 100.00 #N/A
1233 06/02/09 100.00 #N/A
1233 06/02/09 100.00 #N/A


"Ashish Mathur" wrote:

Hi,

One among many approaches. Use the formula in cell E15. B5:E9 carries the
first three columns of data on the first list. B15, C15 and D15 carry the
merchant, data and amount ref on the second list.

=INDEX($E$5:$E$9,MATCH(1,INDEX(($B$5:$B$9=B15)*($C $5:$C$9=C15)*($D$5:$D$9=D15),,),0),1)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Bklynhyc" wrote in message
...
I'm sorry its the other way around,

abcd
merchant date amt ref.
1234 06/01/09 500.00 1
1233 06/02/09 100.00 2
1233 06/02/09 100.00 2
1233 06/02/09 100.00 2
1233 06/02/09 100.00 2

second list w/o reference

abcd
merchant date amt ref.
1234 06/01/09 500.00 1
1233 06/02/09 400.00 2

"Ashish Mathur" wrote:

Hi,

What should the reference number be for the second entry on the second
list
I.e. should it be 2,3,4 or 5.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Bklynhyc" wrote in message
...
Hi,

I would like to link the amounts over two lists of totals,

first list with reference.

abcd
merchant date amt ref.
1234 06/01/09 500.00 1
1233 06/02/09 100.00 2
1233 06/02/09 100.00 3
1233 06/02/09 100.00 4
1233 06/02/09 100.00 5

second list w/o reference

abcd
merchant date amt ref.
1234 06/01/09 500.00 ?
1233 06/02/09 400.00 ?

I've been using ref. number manually to link them, is there a better
way?

Thanks at advance