Excel Lookup Functions

[Paul Adams]

Is there a way on Excel when using a lookup function that instead o
having to click on the other workbook to link it, you can hav
something typed in another cell so that tells it to go off and looku
the correct workbook? Sorry, don't think that makes any sense.

This is why I was wondering.
Each week I refresh a lot of data and save it as that weeks data an
then I have another workbook that has lots of lookups against th
latest weeks data. Each week when I want to get it to link to the ne
weeks data I have to go into the lookups and get it to see the new wee
and not the previous one. its not too bad as I just go into each looku
and change part or the address as thats how the weekly files are save
e.g. wk45, wk46. It would be great if I could get each lookup to loo
at a cell in the same worksheet which told it which worksheet to go t
so each week I just had to change that cell. Any ideas?

Thanks

Pau

 

[N Harkawat]

Take a look at Indirect function
=vlookup(a1,indirect(a2).....
where cell A2 holds the location of the range