Get instant live expert help on I need help with excel reference cell in another sheet dynamically

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I am using a SUMIF nested formula, and I need a way to dynamically reference a column on another sheet using a cell
Solved by Z. Y. in 25 mins
Want to display a cell in an Excel chart dynamically
Solved by S. H. in 17 mins
i need add some reference drop down list based on the another cell in google sheet.
Solved by M. D. in 30 mins
I have a dashboard with cells reference to another source sheet. Sometimes colleagues add rows in the source sheet (cell reference changes). I need to set up such that when the rows are added (cell reference changes) the dashboard is not affected. I.e the cell reference moves as well.
Solved by C. L. in 20 mins
I want to reference a value in one sheet to another, but if the value is 0, then display blank cell in second sheet
Solved by C. U. in 25 mins