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.