| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use a cell to enter a filename in a formula
I am building a filename from two cells(A2, B1) and concatenating them into a
third cell(F2). How do use this third cell in a formula in a forth cell(B2) to bring a figure from the file named in the third cell? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to use a cell to enter a filename in a formula
the indirect function will turn a text reference to a result but it will only
work if the remote workbook is open. -- paul remove nospam for email addy! "John" wrote: I am building a filename from two cells(A2, B1) and concatenating them into a third cell(F2). How do use this third cell in a formula in a forth cell(B2) to bring a figure from the file named in the third cell? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to use a cell to enter a filename in a formula
Thanks Paul, I'll try that.
"paul" wrote: the indirect function will turn a text reference to a result but it will only work if the remote workbook is open. -- paul remove nospam for email addy! "John" wrote: I am building a filename from two cells(A2, B1) and concatenating them into a third cell(F2). How do use this third cell in a formula in a forth cell(B2) to bring a figure from the file named in the third cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Hybrid Mode
