| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? :-) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting a 4 figure number to time in active cell | New Users to Excel | |||
| Page number reference in a cell | Excel Programming | |||
| Converting text to cell reference and column letters to numbers -please help | Excel Worksheet Functions | |||
| Converting data in General Format cell to a number | Excel Discussion (Misc queries) | |||
| Converting column & row numbers to a cell reference | Excel Worksheet Functions | |||
Threaded Mode
