| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP How do you keep the pathway linked to original source?
Hi,
I have used vlook up across different workbooks. All is well until I resave the source as a version 2 in a different folder. I would like the vlookup to remain the same, linked to first workbook - but I find that it adjusts itself to search within the new workbook I have created. Is there anyway I can "lock" the vlookup so that it is not affected by pathway changes or can you only use Vlook up on worksheets within the same workbook? Suggestions are much appreciated - Thanks! Jen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #N/A in linked cell | Excel Discussion (Misc queries) | |||
| How to avoid when linked source data is changed, chart turns blan. | Charts and Charting in Excel | |||
| Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
| Copy tabs(sheets) from workbook without link to original source | Excel Discussion (Misc queries) | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Threaded Mode
