Cross referencing formula
Hello, I am trying to reference cells from one sheet into another. My main sheet has a column where only some cells have a value. If the cell has a value, I want it to pull into my other sheet. Is there a formula for doing this?
I could simply link the cells, but ideally I'd like it to update automatically every time a value is added in my master sheet.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!