How do I find REF errors in Excel?
Follow the steps below to find errors located in your Excel spreadsheet:
How to fix the #REF error in Excel
Follow the method below to fix the #REF error in Microsoft Excel:
1] #REF error caused by deleted column
If a column is deleted, it will trigger a REF error. If you accidentally delete the column, press the Ctrl + Z combination keys to undo the mistake.
2] VLOOKUP with incorrect range references
You can get a #REF error in Excel if there is an incorrect range or column in the VLOOKUP formula. For instance, in the photo above, we have received a #REF error due to inputting the incorrect column (3) in the range.
To fix the issue, place the correct column in the range.
3] INDEX with an incorrect row or column reference
Having an incorrect row or column in your INDEX formula can trigger the #REF error, for instance, in the photo above, we have an incorrect row (7) and an incorrect column (4).
To fix this issue, use the correct column or row in the range. We hope this tutorial helps you understand how to fix the #REF error in Microsoft Excel. Read next: How to automatically insert Decimal Points in Excel.
