View Single Post
  #1   Report Post  
jlc
 
Posts: n/a
Default How do I expand columns in a table and auto change vlookup in wrks

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.