What I would like to do is create some kind of formula that will find a cell location based on the value in another cell. For example:
A1 = 35
What I want to do is locate a cell based on a static column identifier plus whatever the value is in cell A1. Let's say the column was always going to be column 'M', then since A1 = 35, the cell reference I want would be M35.
Does that make sense?
A1 = 35
What I want to do is locate a cell based on a static column identifier plus whatever the value is in cell A1. Let's say the column was always going to be column 'M', then since A1 = 35, the cell reference I want would be M35.
Does that make sense?