#REF! Error Hub: Complete Fix Guide
Pairs with #REF! how-to and Sheets vs Excel.
Recovery order
- Ctrl+Z if delete was recent
- Find #REF! across workbook
- Clean Name Manager
- Rewrite with Table columns
- Edit Links for external files
=SUM(Table1[Amount])
=XLOOKUP(A2,Table1[ID],Table1[Name],"")