Getting VLOOKUP Column number to change when dragged
Results 1 to 2 of 2

Thread: Getting VLOOKUP Column number to change when dragged
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Getting VLOOKUP Column number to change when dragged

    I'm creating a file where a company name is selected from a drop-down menu at the top, and id like it to display the full column of corresponding values for the company from the raw data sheet.

    I originally used (=VLOOKUP($B$1,Table5,3,FALSE) changing the 3 to 4,5,6, etc for each column, however with many companies and roughly 80 values thats no longer viable. Is there a way to make that number 3 (column number) to change as I drag the formula down?

    Thank you for your help!

  2. #2
    Board Regular tyija1995's Avatar
    Join Date
    Feb 2019
    Posts
    596
    Post Thanks / Like
    Mentioned
    14 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Getting VLOOKUP Column number to change when dragged

    Hey,

    Instead of using a static 3 as the column number, try ROW(A3), when you drag it down you'll get ROW(A4), ROW(A5) etc... which translates as 4, 5, etc (As ROW only takes the number at the end)

    =VLOOKUP($B$1,Table5,ROW(A3),FALSE)
    √-1 2³ ∑ π
    …And it was delicious!

Some videos you may like

User Tag List

Tags for this Thread

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
  •