Hi, I want to replace test in this formula with the value in List!B3 C:\Users\Belle\Documents\chandoo\test\[Data.xlsx]Sheet1'!A1 I tried a few things like indirect but it give me errors. Thanks