Re: formula to lookup a value in a range

From: "Sandy Mann" <sandymann2@xxxxxxxxxxxxxx>
Date: Wed, 31 May 2006 20:16:02 +0100

Try:

=INDIRECT("AH"&3+AG1)

Where AG1 contains the 25 resulting from a formula

--
HTH

Sandy
In Perth, the ancient capital of Scotland

sandymann2@xxxxxxxxxxxxxx
Replace@xxxxxxxxxxxxxx with @tiscali.co.uk

"richardmont" <richardmont.28or5y_1149102001.7391@xxxxxxxxxxxxxxxxxxxxx>
wrote in message
news:richardmont.28or5y_1149102001.7391@xxxxxxxxxxxxxxxxxxxxxxxx

Hi. I am trying to find a formula that would lookup the value of a cell
at varying locations in a list. for example =AH3 + 25 to lookup cell
AH28 where the number 25 is taken from a calculation. any suggestions
would be appreciated.

--
richardmont
------------------------------------------------------------------------
richardmont's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=34981
View this thread: http://www.excelforum.com/showthread.php?threadid=547197

References:
- formula to lookup a value in a range
  - From: richardmont

Prev by Date: Re: Merging "space" and character into existing text cell
Next by Date: Re: why>?
Previous by thread: Re: formula to lookup a value in a range
Next by thread: Layering tabs across the bottom of spreadsheets
Index(es):
- Date
- Thread