| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | Make a copy of this spreadsheet to change the selections | ||||||||
2 | Reference Table | Selection | |||||||
3 | Name | Location | Favorite Holiday | Formula type | Name | Location | |||
4 | Rose | Austin | Halloween | vlookup | Jonathan | Los Angeles | |||
5 | Jonathan | Los Angeles | Christmas | vlookup + arrays | Jonathan | Los Angeles | |||
6 | Albert | New York | Kwanzaa | index match | Jonathan | Los Angeles | |||
7 | Li | Miami | Thanksgiving | xlookup | Jonathan | n/a, Excel only | |||
8 | Download excel example | ||||||||
9 |