| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to use a cell reference in a formula
I am trying to pick up info from a cell (B2) defined in a file (F1), which is
not open. With Excel I can do it without problems. My problem is that the filename F1 is defined in another cell (A2) on this worksheet. How can I then reference to cell B2 of file whose name is in A2 of the currently open workbook ? Regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Apply a simple formula to multiple rows? | New Users to Excel | |||
| Is it Possible in a formula to have a formula for cell reference? | Excel Worksheet Functions | |||
| formula to return the value of a cell based on a looked up true reference | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Using a formula in a Hyperlink Cell reference | Excel Discussion (Misc queries) | |||
Threaded Mode
