Forum Discussion

Michael Boyd's avatar
Michael Boyd
Copper Contributor
Jan 10, 2018

Return numbers in a column after a time

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://www.mrexcel.com/forum/redirect-to/?redirect=https%3A%2F%2Fdrive.google.com%2Ffile%2Fd%2F1qy-IeFSA8p_JjF_OLnJbZRDzZ-tFIzXD%2Fview%3Fusp%3Dsharing

No RepliesBe the first to reply

Resources