Let’s say I have a spreadsheet. In columns E through P I have data for each month of the year (January in E1; February in F1; March in G1…etc).
Let’s also assume that in C1 I have a number that represents the current month (8 for August, etc)
I want to have a formula in A1 that represents the data for the current month: in other words, today it should have the value present in L1. Next month it would have the value present in M1. So I want A1 to =("E+C1"1), if that was legal.
(I know I could do this using LOOKUP, but that seems unduly complicated since I know that August is always going to be in L1)