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? :-)

Converting a number into a cell reference
 

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Converting a number into a cell reference
 

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

On Wed, 8 May 2013 17:00:05 +0100, szwanger
wrote:


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? :-)