Lookup and place result in specific cell

[kjones600]

Hello:

I am preparing a redemption model to track how donations will come in over the next 5 years. There are multiple phases for our fundraising campaign and my model is tracking all of the phases. The money will start coming in at different points for each phase.

Here is what I want to do:

Let's say I have $60,000 and I expect that the $60,000 will come in evenly distributed over a 60 month period. I'd like to create a formula or VBA in Sheet 2 that will automatically populate the start month (which matches the start month) and populate the next 59 cells to the right.

Sheet 2.jpgSheet 3.jpg
Sample Worksheet.xlsx

Notice in Sheet 2 Bloc/Phase 1 redemption start months and total amounts are shown

In Sheet 3 you can see I envision a couple things happening

- The redemption matches the month (column) listed in Sheet 2
- The redemption matches the phase name (row) listed in Sheet 2
- Once it matches the column and row it pre-fills with 1/60 of the Bloc amount for 60 rows to the right

Additional
The 60 months will be standard. But if it is tough to program that it can reference a field where the number can be altered.

[FDibbins]

Hi, welcome to the forum

Please upload a sample of your workbook, not a picture of your data.
Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.