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,
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
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,
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,941
Members
448,534
Latest member
benefuexx

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
Back
Top