A Tough One,

Serial

New Member
Joined
May 14, 2008
Messages
20
I think this is a tough one, :confused:
Much appreciation to whoever can help me figure this one out,

Here is the format of the information I have



Name _____Begin Date________End Date_____$Amount
*
Bob1________2/01/08______1/31/09_______$2400
____________ 2/01/09______1/31/10_______$2650
____________ 2/01/10______1/31/11_______$2900
*
Jim3________5/01/07_______4/30/08_______$6000
____________5/01/08_______9/30/08_______$7200
*
*
*
and so on........ ( each name has between 1-7 steps on their schedule, not all the same )
I used the spaces and asteriks to format here,
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Serial

New Member
Joined
May 14, 2008
Messages
20
Re: A Tough One, MY QUESTION:

HERE IS MY NEED:


I need to produce a schedule that shows the $ amount for each name,
during a specific period,


So, I am thinking I am need to lookup each person's name, then based on that look at the periods that are in the cells to the right, then find the period that has my specific period needed in it, ( between begin & end date ) and then return the dollar amount for that period.


Name_____Month1_______Month2_________Month3
Bob_______$ Amount_____$Amount________$Amount
.
.
.
.
etc. etc.
( long list going down )





Your help an assistance is appreciated,
I can't stand the format I get these in,

Thanks,
 

Watch MrExcel Video

Forum statistics

Threads
1,123,305
Messages
5,600,867
Members
414,410
Latest member
4610

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top