IF INDEX MATCH function has circular reference

Options

Hello all,

the following formular gives me a #circular reference mistake. Based on the below can anyone see already why this might be th case?


=IF(INDEX({Vertical}, MATCH([ERP Item Number]@row, {ERP Item Number}, 0)) = [CHECK Vertical]@row, "TRUE", INDEX({Vertical}, MATCH([ERP Item Number]@row, {ERP Item Number}, 0)))

Let me know if you need more context to identify what the mistake might be.


Many thanks,

Dennis

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!