Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Paul Adams
 
Posts: n/a
Default Excel Lookup Functions


Is there a way on Excel when using a lookup function that instead of
having to click on the other workbook to link it, you can have
something typed in another cell so that tells it to go off and lookup
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 and
then I have another workbook that has lots of lookups against the
latest weeks data. Each week when I want to get it to link to the new
weeks data I have to go into the lookups and get it to see the new week
and not the previous one. its not too bad as I just go into each lookup
and change part or the address as thats how the weekly files are saved
e.g. wk45, wk46. It would be great if I could get each lookup to look
at a cell in the same worksheet which told it which worksheet to go to
so each week I just had to change that cell. Any ideas?

Thanks

Paul


--
Paul Adams
------------------------------------------------------------------------
Paul Adams's Profile: http://www.excelforum.com/member.php...o&userid=10468
View this thread: http://www.excelforum.com/showthread...hreadid=276978

  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

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

"Paul Adams" wrote in message
...

Is there a way on Excel when using a lookup function that instead of
having to click on the other workbook to link it, you can have
something typed in another cell so that tells it to go off and lookup
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 and
then I have another workbook that has lots of lookups against the
latest weeks data. Each week when I want to get it to link to the new
weeks data I have to go into the lookups and get it to see the new week
and not the previous one. its not too bad as I just go into each lookup
and change part or the address as thats how the weekly files are saved
e.g. wk45, wk46. It would be great if I could get each lookup to look
at a cell in the same worksheet which told it which worksheet to go to
so each week I just had to change that cell. Any ideas?

Thanks

Paul


--
Paul Adams
------------------------------------------------------------------------
Paul Adams's Profile:

http://www.excelforum.com/member.php...o&userid=10468
View this thread: http://www.excelforum.com/showthread...hreadid=276978



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
how do i get mutiple values using vlookup in excel, lookup value . Abhijeet Excel Discussion (Misc queries) 4 May 19th 05 04:30 AM
Lookup Functions Imran Excel Worksheet Functions 1 November 5th 04 04:35 PM
IF/ LOOKUP FUNCTION - Excel 2000 Chandrashekhar Excel Worksheet Functions 3 November 5th 04 12:02 PM
double lookup, nest, or macro? Josef.angel Excel Worksheet Functions 1 October 29th 04 09:50 AM


All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"