Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Cell Contents Filename
I am trying to create a formula that looks to another cell with a file name
in and return the result. Example: =vlookup(A1,+Sheet1!B6,4,false) Where Sheet1!B6 contains the file path: C:\Folder1\[Testme.xls]TestSheet'!$A1:$A400 End result: I want to create a monthly report that references another sheet with the monthly file names where each month a user could simply go in and enter the new filename for that month and the link would automatically update the value in the report based on the filename that was entered. Any ideas? Thanks in advance! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Cell Contents Filename
You will need to use INDIRECT. Have a look in the Help or search the Google
Archives for examples. Regards Trevor "deeds" wrote in message ... I am trying to create a formula that looks to another cell with a file name in and return the result. Example: =vlookup(A1,+Sheet1!B6,4,false) Where Sheet1!B6 contains the file path: C:\Folder1\[Testme.xls]TestSheet'!$A1:$A400 End result: I want to create a monthly report that references another sheet with the monthly file names where each month a user could simply go in and enter the new filename for that month and the link would automatically update the value in the report based on the filename that was entered. Any ideas? Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use 2nd digit from the left in cell contents for vlookup | Excel Worksheet Functions | |||
get the VLOOKUP function to return the "contents" of a cell? | Excel Worksheet Functions | |||
Cell Contents to identify source Filename | Excel Discussion (Misc queries) | |||
use cell reference,whose contents= a table array name for Vlookup | Excel Worksheet Functions | |||
vlookup and filename returning same result on each sheet. | Excel Discussion (Misc queries) |