Date If Formula

[PGD15]

Hi,

I would like to write an If Formula (think combines vlookup too)

I would like to say if todays today is displayed in x field return the value in y field, if not repeat the formula for yesterday date so like today()-1 etc and repeat this for 2,3 todays.

 

[Special-K99]

Provide some example output detailing how you expect it to look so we're not wasting our time.