| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2002 VLOOKUP in another workbook returns #VALUE
Excel 2002 VLOOKUP in another workbook returns #VALUE if the workbook is
closed. I have the full path and file name in the formula, but it only populates correctly if I open the "looked up" workbook. Is this a Excel 2002 bug, or is there a way around it? My work around for now is to open the workbook, but set my macro to: Application.ScreenUpdating = False |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: Can I convert #N/A to 0 in the VLOOKUP( ) formula ? | Excel Discussion (Misc queries) | |||
| Excel 2002: Vlookup formula not working | Excel Discussion (Misc queries) | |||
| Excel 2002 VLOOKUP Weird | Excel Worksheet Functions | |||
| Vlookup on excel 2002 version | Excel Discussion (Misc queries) | |||
| Excel 2000 VLOOKUP returns #N/A unless press F2 return on source? | Excel Worksheet Functions | |||
Threaded Mode
