Converting a number into a cell reference

[szwanger]

I want to pull a number from a particular cell and then use that t
create a cell reference for the cell in row Q and the column of tha
number, and look up that cell in a different sheet.

For example, let's say Sheet 1, cell K1 contains the number 72. I wan
=formula to return the contents of Sheet 2, cell Q72.

So how do I write this formula? :-

 

[Claus Busch]

Hi,

Am Wed, 8 May 2013 17:00:05 +0100 schrieb szwanger:

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.

try:
=INDIRECT("Sheet2!Q"&K1)


Regards
Claus Busch

 

[Gord Dibben]

You have your answer from Claus but I will stick my nose in to say
there is no "row Q" in Excel.

Rows are numbered and columns are generally lettered.

If you don't learn that difference you will have trouble with Excel
formulas.

Gord