| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP - Saves entire directory structure
Is there any way i can make the function
=VLOOKUP(O9,'C:\Documents and Settings\robic9\My Documents\Gregory - DRE24\Work Packs\[Gregory DRE24 Service Order Summary.xls]Sheet1'!$A$8:$E$182,4) look like this =VLOOKUP(O9,'\Work Packs\[Service Order Summary.xls]Sheet1'!$A$8:$E$182,4) and still work. I want to have the one summarry sheet in the root of one directory and all spreadsheets with the lookup function to keep the lookup to the root kind of like a web page where you have the root and you never have to input the whole directory structure |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CAN VLOOKUP SEARCH AN ENTIRE WORKSHEET INSTEAD OF RANGE OF CELLS | Excel Worksheet Functions | |||
| VLookup function to search an entire workbook | Excel Worksheet Functions | |||
| Slow opening directory structure in Excel 2002 | Excel Discussion (Misc queries) | |||
| Vlookup through entire column | Excel Worksheet Functions | |||
| carrying entire row to another sheet using vlookup | Excel Discussion (Misc queries) | |||
Linear Mode
