Converting a number into a cell reference
I want to pull a number from a particular cell and then use that to create a cell reference for the cell in row Q and the column of that number, and look up that cell in a different sheet.
For example, let's say Sheet 1, cell K1 contains the number 72. I want =formula to return the contents of Sheet 2, cell Q72.
So how do I write this formula? :-)
|