Lookup and dates
Thank you so much, it works perfectly.
Danielle
"muddan madhu" wrote:
try this
in cell D2 put this formula =IF(D$1=$B$2:$B$8,$C2,"") and drag it
across & down
On Oct 24, 2:36 pm, 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
|