How to why your vlookup or sumif creates a circular reference — and how to fix it
- Step 1Upload problematic workbook — Upload the XLSX file showing 'circular reference' warnings in Excel.
- Step 2Run detection — The tool maps formula dependencies and identifies all cycles.
- Step 3Locate the VLOOKUP/SUMIF cell — The report shows the cell reference causing the circular chain.
- Step 4Fix formula range — Adjust the formula range to exclude the cell the formula is in.
Frequently asked questions
VLOOKUP in B2 references B:B — is that always a circular reference?+
Yes if B2 is included in column B's range. Change the lookup range to $C:$D or a table reference that excludes column B.
Can intentional circular references for iterative calculations be excluded?+
The tool reports all circles. Intentional iterative references (e.g. for running totals) will appear in the report — filter them out manually.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.