Dear Sir,

I have the following table in a worksheet :

LIST 1

A B C
1 Staff No Staff Name Account No.
2 2120 John 21645872
3 2121 Sally 21645712
4 2146 Paul 21457126
5 2184 Jenny 21687430

20 3358 Kenny 21477410



Below this list , I have another table beginning from row 26 to be completed :

LIST 2
A B C
D
Account No Staff No Date Amount
26 2184 26/9/06
236.34
27 2121 27/9/06
300.50
28 2121 28/9/06
250.34
29 2146 28/9/06
450.00
30 3358 26/9/06
500.00


250 2120 31/12/06
230.00


I need to fill up the Account Number at A26 to A250 for each staff in List
2 by referring to the staff number in List 1.

May I know what formula I must input at Cell A26 and copy it down to A 250
to get the straight answer ?



Thank You

Low Seng Kuang



--
A36B58K641