Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Vlookup or Hlookup Offset Vary

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Aberdeen, Scotland, UK
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there a way within a Vlookup or Hlookup to reference the offset column/row to another cell. Therfore when the cell changes the lookup values change?

    Thanks

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,026
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-02-19 02:01, Stringt wrote:
    Is there a way within a Vlookup or Hlookup to reference the offset column/row to another cell. Therfore when the cell changes the lookup values change?

    Thanks
    Do you mean that you have a name or range in some cell that specifies e.g., a lookup table that you want to use in a VLOOKUP formula?



  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Aberdeen, Scotland, UK
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    No. I have a Hlookup like this:
    =HLOOKUP($a$1,MyDataRange,2,FALSE)

    Which looks up for value in A1, in the range "MyDataRange" and returns the value from offset row 2.

    I want the formula to look at some other cell to determine which offset row to look at. e.g. if in cell a30 i have the 2 changes to 4, the Hlookup would now look up offset row 4.

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,026
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default


    Stringt: Your latest post is empty. Please try again.

  5. #5
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,026
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-02-19 05:02, Stringt wrote:
    No. I have a Hlookup like this:
    =HLOOKUP($a$1,MyDataRange,2,FALSE)

    Which looks up for value in A1, in the range "MyDataRange" and returns the value from offset row 2.

    I want the formula to look at some other cell to determine which offset row to look at. e.g. if in cell a30 i have the 2 changes to 4, the Hlookup would now look up offset row 4.

    =HLOOKUP($A$1,MyDataRange,A30,FALSE)

    where A30 houses a row number.

    Aladin


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •