• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cell reference instead of value

Belleke

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

Thanks
 
Back
Top