Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 10th 04, 02:37 PM
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  
Old November 10th 04, 02:40 PM
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
how do i get mutiple values using vlookup in excel, lookup value . Abhijeet Excel Discussion (Misc queries) 4 May 19th 05 04:30 AM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM
Lookup Functions Imran Excel Worksheet Functions 1 November 5th 04 03:35 PM
IF/ LOOKUP FUNCTION - Excel 2000 Chandrashekhar Excel Worksheet Functions 3 November 5th 04 11:02 AM
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:13 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017