Getting VLOOKUP Column number to change when dragged

Osarky

New Member
Joined
Jul 5, 2019
Messages
1
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!
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

tyija1995

Well-known Member
Joined
Feb 26, 2019
Messages
766
Office Version
365
Platform
Windows
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,102,335
Messages
5,486,233
Members
407,538
Latest member
kbendelac

This Week's Hot Topics

Top