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.

Instead of the number 3, use:

COLUMN(C:C)

--

Vasant


"jlc" wrote in message
...
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?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"jlc" wrote in message
...
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.