IF INDEX MATCH function has circular reference
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
Best Answer

Do any of the cells or ranges referenced in the formula contain a formula or cell reference to the column the formula is in?
Answers

Do any of the cells or ranges referenced in the formula contain a formula or cell reference to the column the formula is in?

Hey Paul,
thanks for that question :D Check Vertical Row was actually the reference in the same cell as the formula. Changed this to the correct cell reference and now it works just fine.
Cheers and have a great weekend,
Dennis

Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!