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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup 1
vlookup to another worksheet 3
VLOOKUP returning formula 3
Vlookup - multiple tabs 5
Vlookup with changing columns 2
Changing worksheet reference in a VLOOKUP 6
VBA - retrieve data on last create named range from previous inserted named range 0
How do I vlookup 4

Back
Top