Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Offset with hlookup as reference
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Offset with hlookup as reference
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Offset with hlookup as reference
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Offset with hlookup as reference
Tells you how far along the array the value has been found.
-- David Biddulph "DoubleZ" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Offset with hlookup as reference
Thanks David. I understand now.
For anyone reading this post trying to figure out the same thing I was, here is my solution: Originally I was using offset with hlookup as the reference. Instead, I used offset, using the first cell as my reference and using the match function to define how many columns to offset from the reference(e.g. =offset(A1,2,Match(Sheet2!B4,Sheet1!A1:Z1,0)-1,409,2), where Sheet1!A1:Z1 was the range containing values I wanted to look through, and Sheet2!B4 was the cell I wanted to match. Hope that helps. "David Biddulph" wrote: Tells you how far along the array the value has been found. -- David Biddulph "DoubleZ" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PLEASE HELP OFFSET / HLOOKUP / MATCH I HAVE READ OTHER POSTS | Excel Worksheet Functions | |||
HLOOKUP and OFFSET - Any Suggestions | Excel Worksheet Functions | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Does anyone have a solution for nesting an OFFSET in an HLOOKUP? | Excel Worksheet Functions | |||
cell reference from hlookup | Excel Worksheet Functions |