Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup with changing columns
I have a workbook with multiple worksheets. On the first worksheet, I have a
cell that is doing a vlookup on a second worksheet. The second worksheet is a work in progress, and I keep adding columns to it. When I add a column, the column index number on the vlookup don't change automatically. I have tried naming the column on the second worksheet, but evidently you can't use a name for the column index number, but you can use names in the table array, which doesn't help me here. So, is there a way to get my column number (col_index_num) to update automatically when I add columns on my second worksheet? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing the vlookup col_index_num | Excel Worksheet Functions | |||
changing columns | Excel Discussion (Misc queries) | |||
VLOOKUP, changing ranges | Excel Discussion (Misc queries) | |||
VLOOKUP on changing table!!HELP!!lol | Excel Discussion (Misc queries) | |||
Changing columns into rows | Excel Discussion (Misc queries) |