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