Choosing a cell based on date

[Skeidser]

Hi.

I need some help.
I will try and explain it as good as possible.

https://imgur.com/a/c9i9T

The image is an example of what I want it "to look like".
Cells T2:T4 is 2.986 because their date is between 28-07-2017 and 01-12-2017.
Cells T5 and T6 is 3.500 because their date is from 01-12-2017 to 01-01-2018.
T7 (and every cell after that) is 3.200 because its date is after 01-02-2018.

If I type 17-08-2018 in P5 and 2.200 in Q5, I want T14 and after to say 2.200 and T7:T13 to be 3.200. Like this: https://imgur.com/a/aQ9Ex

So everytime I type in a new amount to a date in P and Q, I want T to automatically show what amount was at the different dates.

Is this possible?

I've tried to around a little, but nothing comes close to the automation I want.

[JohnTopley]

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[JohnTopley]

Looking at your image try

=VLOOKUP(P2,$S$2:$T$200,2,1)

[Skeidser]

Just a minute, and I'll upload 2 sample workbooks.

[Skeidser]

Here they are.

(don't mind all the different pages. Only Indtast! and Andelskredit! is relevant for this, the 2 first from the left)


In the first one "Current", all cells in column D in Andelskredit! has the value 2986 (this is typed in manually). The same as B3 in Indtast!.


In the second one "Result", the cells in column D in Andelskredit! has different values based on the months from column A (manually). The values and dates should be based on the value and dates in Indtast!.
So, if I type in a new date at Indtast!A6 and a new value in Indtast!B6, cells in Andelskredit!D:D should change according to the date in Andelskredit!A:A (A20 and D20 are related, A21 and D21 are related, and so on).


Of course, I can do this manually by myself, if something changes at different dates. I'm just trying to make a simplified page (Indtast!) in the workbook, where I can type in dates and values/amounts for all sorts of data, which will then change accordingly across the different pages in the workbook.
If there's a solution for my problem, then I can figure all the other stuff out on my own. If not, then too bad.

[AliGW]

Please provide one simple workbook with your before and after manually mocked up. Make it as easy as you can for those helping, please - get rid of the stuff that isn't relevant.

[Skeidser]

Is this good enough?

Everything on one page (both before and after).

As you see on "before", every payment is the same.
My "after" has changed payments in column AM according to the date the payment was changed (column AO and AP).

The last changed payment is 3200 on february the first (01-02-2018), which then, changes all payments from 01-02-2018 and after.

Can this be automated instead of typed in manually?

To be clear (I hope), I want column AM to be automated/dependent on column AP according to what date the payment was changed (column AO) compared to column AL.

[JohnTopley]

Try

in D12 of Andelskredi

=VLOOKUP(A12,Indtast!$A$3:$B$5,2,1)

copy down