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.