| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup in external file
i have a vlookup to another file and it works fine....then i have a different
vlookup to the same file, different tab and its coming back as an error (#value). why is this? i've tried re-writing it several times but basically the "errro" formula only works if i open the external file...but why don't i have to do that with the other fornula right next to it, reference the same file??...uggh...need help. thx. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| External Reference in Vlookup | Excel Discussion (Misc queries) | |||
| vlookup table in external worksheet | Excel Discussion (Misc queries) | |||
| VLookup to an external Workbook | New Users to Excel | |||
| How do I reference external data from a file, file name found in . | Excel Discussion (Misc queries) | |||
| How do I use vlookup to point to an external file that changes nam | Excel Worksheet Functions | |||
Threaded Mode
