Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to change lookup references
I have a master spreadsheet that calculates formulas from data in another,
multitab spreadsheet. I want to create one master formula that changes the links from one tab to another, which the calculations can reference. It can be done with a search-and-replace of the tab name, but I'd rather use a formula that all the formulas in the master spreadsheet can link into. I thought of using a concactenate formula to build the spreadsheet and tab name, but the calculation formulas don't recognize it. What am I missing? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup function help | Excel Worksheet Functions | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Cell references change when entering new data | New Users to Excel |