Forum Discussion
LOOKUP FORMULA BASED ON HEADERS
Hello, I have some data, which consists of account numbers (rows) by month (headers). I'm attempting to create a formula that will return the value of a cell based on the date I enter. For ex...
You could go a long way toward helping us help you by posting a copy (or a representative sample) of your spreadsheet. Your verbal description is confusing.
An actual sample of the spreadsheet itself is better than an image, and would also enable somebody here to write a formula that works and post it for you to use.