| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
File name from cell
=VLOOKUP(C$2,[Malcolm.xls]Login!$M$1:$N$31,2,FALSE)
in the above formula, how to make the file pick from cell? Something like &A3&".xls"? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking to another file using file reference typed cell | Excel Worksheet Functions | |||
| Autoname a save as file from a cell in a read only file | Excel Discussion (Misc queries) | |||
| Is it possible to link cell formatting in Excel from file to file | Excel Discussion (Misc queries) | |||
| when inserting a file name in a cell how do you remove file type | Excel Worksheet Functions | |||
| Saving worksheet in new file with date AND cell value as file name | Excel Discussion (Misc queries) | |||
Threaded Mode
