formula to lookup a value in a range

[richardmont]

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.

[Ron Coderre]

Try something like this:

A1: (a number)

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

Does that help?

Regards,
Ron

[Chip Pearson]

Use the INDIRECT function. E.g,

=INDIRECT("AH"&3+A1)




"richardmont"
<[email protected]> wrote
in message
news:[email protected]...
>
> 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...o&userid=34981
> View this thread:
> http://www.excelforum.com/showthread...hreadid=547197
>

[CarlosAntenna]

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

--
Carlos

"richardmont" <[email protected]>
wrote in message
news:[email protected]...
>
> 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...o&userid=34981
> View this thread: http://www.excelforum.com/showthread...hreadid=547197
>

[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

[email protected]
[email protected] with @tiscali.co.uk


"richardmont" <[email protected]>
wrote in message
news:[email protected]...
>
> 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...o&userid=34981
> View this thread: http://www.excelforum.com/showthread...hreadid=547197
>