How do I expand columns in a table and auto change vlookup in wrks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a database and want to lookup data that is added to a worksheet
template.

Once I create the template for the worksheet, I want to be able to expand
the table and still have the correct info in the worksheet cell.

Formula:
=VLOOKUP($A$4,'Sal Dtbse'!$A$2:$DZ$201,3)

If I add a column in 'Sal Dtbse', the data in the worksheet will still
reference col #3, not the actual data that should be there.
 
Not too much info to make a viable suggestion!

*Where* are you inserting the column(s)?
In front of Column A?
In the middle of the data list?
At the end, after Column DZ?

AND, what do you want to change in the formula?
The entire size of the table array and/or the column index number?
 
Back
Top