Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    Dynamic Range across rows

    Hi

    I use this =OFFSET(Lookup!$A$1,0,0,COUNTA(Lookup!$A$1:$A$13), 1) to look down column A for the dynamic range.

    What needs to be changed to look across rows rather an columns?

    Any suggestions would be greatly appreciated.

    regards

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 105 Times in 90 Posts
    VLOOKUP searches in columns, HLOOKUP searches in rows.

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,829
    Thanks
    136
    Thanked 483 Times in 460 Posts
    try
    =OFFSET(Lookup!$A$1,0,0,1, COUNTA(Lookup!$A$1:$Z$1))

    zeddy

  4. The Following User Says Thank You to zeddy For This Useful Post:

    verada (2016-09-18)

  5. #4
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post
    That looks just right. Thanks again

Posting Permissions

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