| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
referring to a sheet in another file
I have a file that has a sheet/tab for each department e.g. 85,86,87,88 etc.
and each tab has sales info for all the items in that dept. In another file i have an item (dept#, class, style, etc) and want to look up the sales info in the other file....but my lookup formula must know which sheet to look on. INDIRECT function doesn't work as it can't do external file references, correct? thx. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referring to a variable cell on another sheet | Excel Worksheet Functions | |||
| Referring to Sheet locations in a formula | Excel Worksheet Functions | |||
| Formula referring to a different sheet | Excel Discussion (Misc queries) | |||
| Referring to a list in one sheet to another column on a different | Excel Discussion (Misc queries) | |||
| referring to previous sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
