| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links work in one workbook, not in another
I'm using the following formula in two different workbooks:
=IF(F4=1,VLOOKUP(D4,'S:\payroll folder\[vacation info.xls]Summary'!$B$3:$F$110,5,FALSE),VLOOKUP(D4,'S:\payro ll folder\[more vacation info.xls]Summary'!$B$4:$F$103,5,FALSE)) It is entered exactly the same way in both workbooks, but only works from one. Note: For security reasons I changed the name of the folder and .xls file. In the second workbook, I get an #N/A error. In both workbooks, F4=1 and D4=173010. The "vacation info" sheets are sorted by employee number (D4). Any ideas? -- Adios, Clay Harryman |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My workbook links are not updating (its 30,000 KB size workbook). | Excel Discussion (Misc queries) | |||
| My links to another workbook don't work | Excel Discussion (Misc queries) | |||
| DO NOT update links doesn't work for me. | Excel Discussion (Misc queries) | |||
| links within excel don't work when workbook is e-mailed - why ? | Excel Discussion (Misc queries) | |||
| My links no longer work . . . | Excel Discussion (Misc queries) | |||
Threaded Mode
