M
Mr. Low
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
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