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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!