Results 1 to 4 of 4

Thread: Combining HLOOKUP, INDIRECT and ROW Functions

  1. #1
    Neophyte tahas's Avatar
    Join Date
    Sep 2012
    Location
    Richmond Hill, ON Canada
    Posts
    3
    Articles
    0

    Combining HLOOKUP, INDIRECT and ROW Functions



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All,

    Wondering if there is a way that my formula could auto pick up the data from next row instead of manually changing the row to 3 and so on. Please see my formula below:
    =HLOOKUP(C$6,INDIRECT($A7&"!$B$6:$AA$56"),2,FALSE)

    Thanks for your help in advance.
    Taha

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,290
    Articles
    0
    Excel Version
    Office 365 Subscription
    Maybe like this:

    =HLOOKUP(C$6,INDIRECT($A7&"!$B$6:$AA$56"),ROWS(C$6:C6)+1,FALSE)
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Neophyte tahas's Avatar
    Join Date
    Sep 2012
    Location
    Richmond Hill, ON Canada
    Posts
    3
    Articles
    0
    Thank you so much, Ali. It worked like a charm.

    Take care,
    Taha

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,290
    Articles
    0
    Excel Version
    Office 365 Subscription
    You're welcome!

    In the future, please do not cross-post the same query on other forums without links. See here to find out why: http://www.excelguru.ca/content.php?184
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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