Vlookup Formula

**reachhari** · 12-28-2011, 02:27 PM

Hi,

Yes it is very much possible, find attached an excel file which will give you an idea of how to use it. I have made this for one of my client.

You have to name your data and call them in the vlookup using indirect function. In the attached file if you select each month data you can see the name in the namebox

Regards,
Hariharan R

**efernandes67** · 12-28-2011, 04:15 PM

Hi,

As you can see the formulas I posted, refer to diferente files names. How can I do this with 'INDIRECT' function? Is there another way?

Elio

**Osvaldo Palmeiro** · 12-28-2011, 06:35 PM

Hi Elio.
Try this.
Note that INDIRECT function only works meanwhile the source file is open. After closed, as the first time that your sheet is recalculated the funtion will return an error.

=VLOOKUP($B$2,INDIRECT("'["&INDIRECT(ADDRESS(ROW(),COLUMN()-1,4,1))&"2011.xlsx]Sheet1'!$B:$C"),2,FALSE)

**efernandes67** · 12-28-2011, 07:29 PM

Osvaldo, obrigado!

It is working. I saw in Internet that if I want to work with the lookup files closed, I have to have Morefunc.xll addin. Where can I find it? All the links that I found are 'dead'!.

Elio Fernandes