How do I prevent VLOOKUP from breaking after I add a column to a named range?
Fresh3 days ago
Mar 15, 202621644 viewsConfidence Score0%
0%
Problem
My Excel worksheet contains a lot of VLOOKUPs on a named range that I have defined. Now, when I added a column in the middle of my named range, the VLOOKUPs that reference columns after the inserted column are now broken. I understand the problem, but what is the best way to fix? Is there a way to …
Error Output
INDEX(MyTableData, MATCH("RowLabel", RowList, 0), MATCH("ColumnLabel", ColumnList,0))Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How do I prevent VLOOKUP from breaking after I add a column to a named range?
Low Risk
Personally, I prefer using an combo for lookups instead of . Here's an example off the Pokedex I was compiling for my niece. To get Squirtle's Hidden Ability, I'd use this formula: This yields the same result as: One good thing about INDEX-MATCH is …
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix