Vlookups and scope

[matrixfan0831]

I'm wondering if I have a workbook A in a far away folder than workbook B, can I use a vlookup on workbook B from workbook A? If so do I have to open workbook B? Sorry I know it sounds trivial but I'm new to VB and was just wondering.

 

[matrixfan0831]

bump

 

[Y2K SE]

I assume you are referencing Excel. Yes, you can reference another workbook in a VLOOKUP function. The easiest way to do this is to have the source workbook open, then select the source array as you normally would. Excel will build the appropriate cell references for you.