I am working with this formula IF(ISBLANK([MoH ID]@row) = true, "", IFERROR(VLOOKUP([Val ID MoH]@row, {2.1 MoH Range 1}, 16, 0), "Error ID Trámite")). It worked for a few weeks and then suddenly when I open the sheet the formula result is #CIRCULAR REFERENCE. After few days, I opened the same sheet and the formula shows the correct result. Can you help me to understand why this is happening?
Thank you,