Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup a particular cell in another excel workbook
I want to be able to type in a workbook name in cell A1, example "05-03-10
Sales", and in cell B1 pull in cell A3 under the tab SALES in that workbook automatically. That way the date can be changed randomly and it automatically looks for that workbook. example change "05-03-10 SALES" to "05-04-10 SALES" and cell B1 changes. is there a way to write a formula in cell B1 that depending on the name in cell A1 it looks up that workbook, please help!! Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linked workbook cell returns 0 is source workbook cell is blank? | Excel Worksheet Functions | |||
lookup value from different workbook | Excel Discussion (Misc queries) | |||
lookup in 1 workbook to get data for another workbook | Excel Worksheet Functions | |||
Lookup and SUM Value from Another Workbook | Excel Discussion (Misc queries) | |||
workbook lookup | Excel Discussion (Misc queries) |