lookup problem

[Jaan]

Hi
I like to create formula to lookup data two rows below
Ex:
A1=Hyperlink(sheet2 part nr1)
A2=Hyperlink(sheet2 part nr2)
B1=???(Sheet2 part nr1 two rows down)
B2=???(Sheet2 part nr2 two rows down)
How can I create this formula
Any ideas are welcome

 

[Bernie Deitrick]

Jaan,

You can change your hyperlink from

=HYPERLINK("Address in String form","Text for HyperLink")

to something like:
=HYPERLINK(C3,"Text for HyperLink")
where C3 has Address in String form

Then you can use this to get the value 2 cells down from the hyperlink location:
OFFSET(INDIRECT(C3),2,0)


If you don't want to do that, then you can use a combination of INDEX and MATCH, where you look for
the value returned by the hyperlink on the sheet - but that will only work if your values are
unique.

HTH,
Bernie
MS Excel MVP

 

[John Bundy]

I'm kind of confused by your wording but look at the function Offset, it lets
you select a reference point and then move however many rows or column you'd
like from there.