I'm trying to create a formula (I'm thinking I should be using a VLOOKUP formula) in my spreadsheet on cell K68 to display a different daily percentage that would exist in cell range F57:F80.
For example,
On 12/17, I want cell K68 to display 1%
On 12/18, I want cell K68 to display 2%
On 12/19, I want cell K68 to display 3%
12/17 - F57 = 1%
12/18 - F58 = 2%
12/19 - F59 = 3%
Hopefully this makes sense. Any suggestions would be appreciated.
Thanks!
For example,
On 12/17, I want cell K68 to display 1%
On 12/18, I want cell K68 to display 2%
On 12/19, I want cell K68 to display 3%
12/17 - F57 = 1%
12/18 - F58 = 2%
12/19 - F59 = 3%
Hopefully this makes sense. Any suggestions would be appreciated.
Thanks!