Lookup and dates
Put this formula in D2:
=IF($B2=D$1,$C2,"")
Then copy across and down as required.
Hope this helps.
Pete
On Oct 24, 10:36*am, Danie wrote:
I have a worksheet with the following data:
Name * Date * * * * * * Amt * * *10/01/08 * 10/02/08 * *10/03/08 ......
ABC * * *10/02/08 * * * 100
XYZ * * *10/03/08 * * * *200
When I enter the date and the Amt in Cols B and C I would like the Amt to be
inserted into the corresponding date column. *In my example 100 should go to
col. E and 200 should go into col. F. *Is there a way to do this.
Thanks,
Danielle
|