| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
reference a closed filed from a cell and formula in an open file
scenario:
file ABC.xls has the number 5 in A1 (a closed file) file XYZ.xls has the number 10 in A1 (a closed file) file choose.xls (an open file) has EITHER ABC or XYZ in cell A1 and ~some formula in A2 i need a formula for cell A2 (choose.xls) that will display EITHER 5 or 10 in A2, depending on what is in cell A1 (EITHER ABC or XYZ)?? thanks -- dh13134 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move entire row of data from open to closed file by entering date | Excel Discussion (Misc queries) | |||
| Reference closed files in formula | Excel Worksheet Functions | |||
| Reference closed files in formula | Excel Worksheet Functions | |||
| VBAProject remains open after file is closed | Excel Discussion (Misc queries) | |||
| Use INDIRECT function to reference a value in closed file | Excel Worksheet Functions | |||
Threaded Mode
