I dont know Excel, but in Google sheets they're called "named ranges" and you can name from the toolbar up top. Index+match > vlookup Because it survives column deletions and additions. More robust.
Replying to @NickatFP @ccchaircut
Since you've been dodging my chess challenge, I'll issue you a new one. Your excel vs. my google sheets.
8:13 AM - 18 Oct 2018
0 replies
0 retweets
1 like
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.