+ Reply to Thread
Results 1 to 4 of 4

How to offset a vlookup tabe array by x columns

  1. #1
    Registered User
    Join Date
    02-09-2010
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    22

    How to offset a vlookup tabe array by x columns

    Is there a way to make a single column table array in a vlookup dynamic and move the table array by x columns to the right? The number of columns to the right would be defined in the same row as the vlookup formula.

  2. #2
    Registered User
    Join Date
    02-09-2010
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    22

    Re: How to offset a vlookup tabe array by x columns

    ScreenShot001.jpg
    vlookup dynamic table array.xls

    eg screenshot and spreadsheet attached.

    so the vlookup would return #n/a at row number 12 as the number 1 doesn't appear in table 2

  3. #3
    Forum Contributor
    Join Date
    08-04-2011
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2007
    Posts
    109

    Re: How to offset a vlookup tabe array by x columns

    Insert in C5, copy down:
    =VLOOKUP(B5,OFFSET($C$20,0,A5):OFFSET($C$28,0,A5),1,FALSE)

  4. #4
    Registered User
    Join Date
    02-09-2010
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    22

    Re: How to offset a vlookup tabe array by x columns

    Fantastic!! Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1