C
claude jerry
I have Following Date in sheet1
Sheet1
ColA ColB ColC ColD
Room ChqNo ChqDt Amt
1 11551 01-06-09 500
2 25516 01-07-09 300
3 55159 01-08-09 250
1 11552 01-07-09 500
4 88192 01-08-09 300
2 25517 01-08-09 200
3 55160 01-11-09 200
1 11553 01-11-09 200
3 55161 01-12-09 200
4 88192 01-12-06 200
In Sheet 2 I Have following
Room Chq1 Chq2 Chq3 Chq4 Chq5
1
2
3
4
I need a formula to get the cheque amt in respective room
Final result should look this way
Room Chq1 Chq2 Chq3 Chq4 Chq5
1 500 500 300 0 0
2 300 200 0 0 0
3 250 200 200 0 0
4 300 200 0 0 0
Sheet1
ColA ColB ColC ColD
Room ChqNo ChqDt Amt
1 11551 01-06-09 500
2 25516 01-07-09 300
3 55159 01-08-09 250
1 11552 01-07-09 500
4 88192 01-08-09 300
2 25517 01-08-09 200
3 55160 01-11-09 200
1 11553 01-11-09 200
3 55161 01-12-09 200
4 88192 01-12-06 200
In Sheet 2 I Have following
Room Chq1 Chq2 Chq3 Chq4 Chq5
1
2
3
4
I need a formula to get the cheque amt in respective room
Final result should look this way
Room Chq1 Chq2 Chq3 Chq4 Chq5
1 500 500 300 0 0
2 300 200 0 0 0
3 250 200 200 0 0
4 300 200 0 0 0