Getting VLOOKUP Column number to change when dragged

[Osarky]

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!

 

[tyija1995]

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)