Converting a number into a cell reference

S

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

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top