Lookup and dates
 

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

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

Lookup and dates
 

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

Lookup and dates
 

Thank you so much Pete. It works perfectly.

Danielle

"Pete_UK" wrote:

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

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

Lookup and dates
 

You're welcome, Danielle - thanks for feeding back.

Pete

On Oct 24, 2:39*pm, Danie wrote:
Thank you so much Pete. *It works perfectly.

Danielle