vlookup with variable workbook and sheet

**nzeg** · 08-09-2009, 12:16 PM

Hello

I have use the command vlookup
=VLOOKUP(A10;'C:\seaa\[2009-07-pcnew.xls]PC_mo_YTD'!$A$2:$N$100;9;FALSE) and it works fine but I like to replace the file name ('C:\seaa\[2009-07-pcnew.xls]PC_mo_YTD') and the range ($A$2:$N$100) with variables

Thanks in advance

Nikos

**arthurbr** · 08-09-2009, 12:18 PM

Hi and welcome to the board
Maybe you need to have a look at the INDIRECT function

**nzeg** · 08-09-2009, 03:54 PM

Thank you for your quick reply.

I had use INDIRECT but no chance maybe the syntax is wrong

The attached file is a sample

**arthurbr** · 08-10-2009, 02:36 AM

Hi, I added a workbook with an example.
Keep in mind that referencing another workbook with vlookup implies that workbook is open.
Otherwise you will need a VBA solution.