refrence in vlookup

R

R.VENKATARAMAN

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

-----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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Defining a dynamic table_array for vlookup 9
Need Help in VLOOKUP (second attempt) 8
How to insert VLOOKUP function in VBA? 6
Referencing Defined Name in another workbook 2
Vlookup syntax format 16
vlookup not working with defined name 3
VBA Code to Return Text Embeded in the VLOOKUP Function 10
Table_Array arg for VLOOKUP 1

Top