| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I reference the value of a cell within a formula?
If the file is open then you don't need the path to it - you only need:
'[filename.xls]Sheet name'!range In your VLOOKUP you are putting square brackets around everything, but these only need to go around the filename, so it won't work. If R18 contains "052306" and the file 052306.xls is open, then the formula should be: =VLOOKUP(N16,INDIRECT("'["&R18&".xls]Sheet 1'!$A$2:$Z$26"),26,FALSE) Hope this helps. Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formula with cell reference decreasing automatically | Excel Discussion (Misc queries) | |||
| how to paste formula but reference a fixed cell | Excel Discussion (Misc queries) | |||
| Function/ formula to output a cell reference | Excel Worksheet Functions | |||
| How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
| copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
Threaded Mode
