Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup between dates | Excel Discussion (Misc queries) | |||
lookup/vlookup for dates, please help! | Excel Worksheet Functions | |||
How to lookup the dates of a list that are only the first of the . | Excel Worksheet Functions | |||
Lookup a date between other dates | Excel Worksheet Functions | |||
Lookup a date between other dates | Excel Worksheet Functions |