Vlookup Formula

[efernandes67]

Hi,

I have these formulas. Instead of writing each formula for each month, is it possible to change it, so it recognizes the name of the month on the left?

Month Value
Jan =VLOOKUP($B$2;[Jan2011.xlsx]Sheet1!$B:$C;2;0)
Feb =VLOOKUP($B$2;[Feb2011.xlsx]Sheet1!$B:$C;2;0)
Mar =VLOOKUP($B$2;[Mar2011.xlsx]Sheet1!$B:$C;2;0)
Apr =VLOOKUP($B$2;[Apr2011.xlsx]Sheet1!$B:$C;2;0)

Regards,
Elio Fernandes

[reachhari]

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]

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]

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.

Please Login or Register  to view this content.

[efernandes67]

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