How can I determine when a formula is needed in a sheet and when cell linking is required.
![Nandini](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I am trying to link two sheets with similar columns. Until now I was using cell linking and when I updated the information in one sheet the same was duplicated in the other sheet. But I found out that INDEX and MATCH formulas can also be used and have been used in the PMO template so wanting to know what's the difference and how to determine which function should be used when.
Best Answer
-
Hey @Nandini
index march can be used when two columns are the same in separate sheets to bring data from a third column. Cell linking can be used when there aren’t any additionally columns to match. The key difference is that index match is automatic, and cell linking is usually done manually and is a bit more tedious.
i always try to index match when possible
hope this helps!
Sincerely,
Jacob Stey
Answers
-
Hey @Nandini
index march can be used when two columns are the same in separate sheets to bring data from a third column. Cell linking can be used when there aren’t any additionally columns to match. The key difference is that index match is automatic, and cell linking is usually done manually and is a bit more tedious.
i always try to index match when possible
hope this helps!
Sincerely,
Jacob Stey
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives