R R.VENKATARAMAN Jan 20, 2004 #1 can the second argument "table_array" in vlookup function be in some other workbook and should it be in the same workbook
can the second argument "table_array" in vlookup function be in some other workbook and should it be in the same workbook
K K Dales Jan 20, 2004 #2 -----Original Message----- can the second argument "table_array" in vlookup function be in some other workbook and should it be in the same workbook . Click to expand... It can be in another workbook, but with a performance penalty unless that workbook is also open at the time you are calculating the cells.
-----Original Message----- can the second argument "table_array" in vlookup function be in some other workbook and should it be in the same workbook . Click to expand... It can be in another workbook, but with a performance penalty unless that workbook is also open at the time you are calculating the cells.