formula to lookup a value in a range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

richardmont - 31 May 2006 19:55 GMT

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

Reply to this Message

Chip Pearson - 31 May 2006 20:09 GMT

Use the INDIRECT function. E.g,

=INDIRECT("AH"&3+A1)

"richardmont"

> Hi. I am trying to find a formula that would lookup the value
> of a cell
[quoted text clipped - 3 lines]
> suggestions
> would be appreciated.

Reply to this Message

CarlosAntenna - 31 May 2006 20:11 GMT

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

--
Carlos

> 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.

Reply to this Message

Ron Coderre - 31 May 2006 20:11 GMT

Try something like this:

A1: (a number)

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

Does that help?

Regards,
Ron

Signature

Ron Coderre

Reply to this Message

Sandy Mann - 31 May 2006 20:16 GMT

Try:

=INDIRECT("AH"&3+AG1)

Where AG1 contains the 25 resulting from a formula

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

Reply to this Message