| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using data in cell for a formula
I would like to use data in a cell to return a value that is used to refer to
another spreadsheet. In other words, if I have the value Scott in Cell A3, I would like the formula in B3 to use the value in A3 to get information in another workbook that has the name Scott as a worksheet. I.e., the formula in B3 will be ='F:\BUDGETS\[Time1.xls]Scott'!$J$31, where it is getting the value in A3 to refer to the worksheet named Scott in the Workbook named Time1.xls. If I change the Value in A3 to Bill, it should now return the value that is in 'F:\BUDGETS\[Time1.xls]Bill'!$J$31. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell references change when entering new data | New Users to Excel | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| ENTER A FORMULA IN A CELL TO UTILIZE THE IMPORT DATA FUNCTIONS? | Excel Worksheet Functions | |||
| need help creating formula based on cell value | Excel Discussion (Misc queries) | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Threaded Mode
