| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup in book which will change.
Hi,
I'm creating a template to search in a price list in a closed book, this book will change its name every week, so I want to put the name of the book in a cell and use this name as an argument in a vlookup function. Is this feasible? Ex: A1 - PriceList0.xls C10 - =VLOOKUP(B10,'P:\PRICES\[PriceList0.xls]Products'!$A$2:$B$10,2,0) Now in C10 I'd like to change the formula to use the value in A1. Any suggestions? Regards, -- Beto |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does sheet formatting change when pasting into a new book? | Excel Discussion (Misc queries) | |||
| How do I change a work book number. I always getting workbook 1 | Excel Discussion (Misc queries) | |||
| No need of save change confirmation at closing book | Excel Discussion (Misc queries) | |||
| Change Work Book Caption | Excel Discussion (Misc queries) | |||
| Change Path names in copied work book | Excel Worksheet Functions | |||
![Beto[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
