IF INDEX MATCH function has circular reference

Dennis92

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

Paul Newcome

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

Paul Newcome

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

Dennis92

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

Paul Newcome

Happy to help. 👍️