I think that MATCH returns a value, not a reference cell.

"David Biddulph" wrote:

MATCH?
--
David Biddulph

"DoubleZ" wrote in message
...
In excel 2007 I basically want to use the offset function to return a long
list. However, I need the returned list to be based upon a certain input
value. So I tried to use offset with hlookup as the reference value, but
it
didn't work. I now understand why since hlookup returns a value, not a
reference.

Is there a way to return a reference cell rather than that cell's value?

Thanks.