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 |
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 |
All times are GMT +1. The time now is 04:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com