formula to lookup a value in a range

[richardmont]

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

 

[Chip Pearson]

Use the INDIRECT function. E.g,

=INDIRECT("AH"&3+A1)




"richardmont"
in message
news:[email protected]...

 

[CarlosAntenna]

=OFFSET(AH3,<calculation for number of rows>,0)

--
Carlos

"richardmont" <[email protected]>
wrote in message
news:[email protected]...

 

[Ron Coderre]

Try something like this:

A1: (a number)

B1: =OFFSET(AH3,A1,,,)

Does that help?

Regards,
Ron

 

[Sandy Mann]

Try:

=INDIRECT("AH"&3+AG1)

Where AG1 contains the 25 resulting from a formula

--
HTH

Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk


"richardmont" <[email protected]>
wrote in message
news:[email protected]...