Values to be drawn as per lookup range

[mmr1]

Hi,


I required a formula to Cell no. C4 in a full Sheet, values to be pulled there as referring the Task & ledger codes from Sheet1, When i drag the formula from C4 to C11 values to be reflect there from sheet1 to full Sheet as per Task & Ledger Codes.


Thanks,

Book2
	A	B	C
1	Task Code	ledger	value
2	001	52000200
3	001	52000201
4	002	52000200
5	002	52000201
6	003	52000200
7	003	52000201
8	004	52000200
9	004	52000201
Full Sheet

Book2
	A	B	C	D	E	F
1	Task Code	ledger	value	Task Code	ledger	value
2	001	52000201	68,021.42	001	52000200	68,021.42
3	002	52000201	107,983.50	002	52000200	258,182.45
4	003	52000201	148,588.60	003	52000200	126,574.18
5	004	52000201	32,426.05	004	52000200	(275.00)
Sheet1

 

[mmr1]

Hi,

Could you please someone look into this above question.

Thanks,