• 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.

Update a formula reference based on another cell

dparteka

dparteka

Member
I’ve attached two workbooks, we’ll call the 101A-000 the data file, the 1422A-000 has a reference to that data file. I simply want to create a formula in 1422A-000 that will update based on another cell, you’ll find more explanation on that in the spreadsheet. Thank you for looking and I greatly appreciate the help.
 

Attachments

  • 101A-000 QCR.xlsx
    8.1 KB · Views: 3
  • 1422A-000 QCR.xlsx
    11.4 KB · Views: 4
Thanks Hui... I do completely understand your formula and it seems like it should work but it's not working for me, it's returning a #REF!. I tried a few tweaks but no change, what am I missing, do you have any ideas why it's not working for me?
 
Attached are the two workbooks... 1422A-000 QCR has the formula you provided that is returning a #REF! in cell A5
 

Attachments

  • 101A-000 QCR.xlsx
    8.1 KB · Views: 1
  • 1422A-000 QCR.xlsx
    10.6 KB · Views: 2
Dparteka

Excel can only use Indirect when the destination workbook is open
Which is why you are getting the error
 
That I did not know. So, when you have both workbooks opened the formula works for you? I still get the #REF!, I guess I'll have to come up with a plan-B on this... thanks for the Hui
 
You must log in or register to reply here.
Back
Top