| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheet protection code conflicts with Pivot Table "auto refresh" | Excel Discussion (Misc queries) | |||
| auto fill data into a cell from a lookup table | Excel Discussion (Misc queries) | |||
| Pivot Table Auto Update Data Source? | Excel Worksheet Functions | |||
| Pivot table and filter | New Users to Excel | |||
| ability to auto file column(s) on a pivot table | Excel Worksheet Functions | |||
Threaded Mode
