Index Match - Circular reference
I'm getting a circular reference error with the following formula. I understand why I'd get the error, but how would I approach the following?
For the sake of example, I have 2 columns (ColA and ColB). ColA has an ID number, and ColB has a description. ColA may have multiple records with the same ID number. I want ColB to return the description from elsewhere in the sheet if the the ID in ColA matches any other row's ID.
Formula in ColB:
=INDEX(ColB:ColB, MATCH(ColA@row, ColA:ColA, 0))
Any help is greatly appreciated.
Thanks in advance!
Answers
-
What does "Elsewhere in the sheet" mean? Can you screen shot some anonymized data? Maybe mock up what you want the result to be?
-
Hi James - thanks for the response. What I mean is I want ColB to be populated with the ColB value from another row where ColA matches.
Help Article Resources
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
Check out the Formula Handbook template!