Return numbers in a column after a time

[mike4777]

I am trying to return all the numbers that appear in column L in column W, but only after a certain number of days (that changes depending on the amounts). This is for an investment program that releases locks and releases funds after a certain time period depending on the amount.

The table in T8:U12 gives the amounts/days capital is tied up. So in the W column, I'm looking for a formula that will return the same amount in column L after a certain number of days in column A. I'm pretty sure this will be a sumproduct/lookup formula, but I still don't fully understand how these work. Any help would be appreciated.

https://drive.google.com/file/d/1qy-IeFSA8p_JjF_OLnJbZRDzZ-tFIzXD/view?usp=sharing

 

[mike4777]

Anyone willing to help?

 

[PaddyD]

Almost certainly

You'll maximise your chances of a reply if, rather than linking to files, you post a relevant snapshot of your data directly. For a variety of reasons many here (me included) are reluctant / unable to access files on file sharing sites.

Here's how to post to the board:

https://www.mrexcel.com/forum/about-board/508133-attachments.html