Home » Forums » Open Source Learning Center » Question and Answer

using VLOOKUP with close files

Submitted by saruti on 22 October, 2012 - 10:56

I understand that Microsoft doesn't support using VLOOKUP with closed workbooks when the table array (second parameter) is dynamically built. I have tried indirect.ext but that doesn't work like VLOOKUP because it will only retrieve 1 row at a time and it is slow. I tried the PULL code but either I'm doing something wrong or the code I found doesn't work with Excel 2010 because Excel keeps crashing. What other options do I have? I am not a VB programmer.

Thanks
Sam

‹ Question if statement: if Y, then concatenate three columns into one ›
»
Almir's picture

using VLOOKUP with close files

Submitted by Almir on 23 October, 2012 - 09:41.

Do you need only one row as a result, or all rows that satisfy condition? If you need all rows, use Advanced filter.

You can reference closed workbook if you know sheet name (e.g. sheet1!$A$1:$D$8)

»