Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Converting a number into a cell reference

11 views
Skip to first unread message

szwanger

unread,
May 8, 2013, 12:00:05 PM5/8/13
to

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




--
szwanger

Claus Busch

unread,
May 8, 2013, 1:00:36 PM5/8/13
to
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

Gord Dibben

unread,
May 8, 2013, 3:03:12 PM5/8/13
to
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
0 new messages