Spreadsheet: 100589d1298921055-vlookup-or-similar-on-multiple-criteria-records
Sheet: RAW DATA

[NAME] | Date | Competition | Golf Course | Team | Player | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Total | Par | To Par | W | D | L
1 | 2010-08-08 00:00:00 | Gypsy Cup 1 | [NAME] | Team T-C | [NAME] | 4 | 3 | 5 | 4 | 4 | 5 | 3 | 4 | 2 |  | 27 |  | W
1 | 2010-08-08 00:00:00 | Gypsy Cup 1 | [NAME] | Team T-C | [NAME] | 3 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 2 |  | 27 |  | W
1 | 2010-08-08 00:00:00 | Gypsy Cup 1 | [NAME] | Team K-S | [NAME] | 3 | 4 | 4 | 4 | 4 | 2 | 5 | 4 | 4 |  | 27 |  |  |  | L
1 | 2010-08-08 00:00:00 | Gypsy Cup 1 | [NAME] | Team K-S | Iain Stirling | 4 | 4 | 4 | 4 | 5 | 4 | 4 | 6 | 4 |  | 27 |  |  |  | L
2 | 2010-08-22 00:00:00 | Gypsy Cup 2 | [NAME] | Team T-C | [NAME] | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 4 | 4 |  | 27 |  | W
2 | 2010-08-22 00:00:00 | Gypsy Cup 2 | [NAME] | Team T-C | [NAME] | 5 | 6 | 3 | 4 | 4 | 4 | 6 | 4 | 3 |  | 27 |  | W
2 | 2010-08-22 00:00:00 | Gypsy Cup 2 | [NAME] | Team K-E | [NAME] | 4 | 5 | 5 | 4 | 4 | 4 | 3 | 3 | 3 |  | 27 |  |  |  | L
2 | 2010-08-22 00:00:00 | Gypsy Cup 2 | [NAME] | Team K-E | [NAME] | 5 | 6 | 5 | 4 | 7 | 4 | 6 | 3 | 6 |  | 27 |  |  |  | L
3 | 2010-10-03 00:00:00 | Gypsy Cup 3 | [NAME] | Team T-C | [NAME] | 4 | 4 | 5 | 4 | 3 | 4 | 3 | 3 | 4 |  | 27 |  | W
3 | 2010-10-03 00:00:00 | Gypsy Cup 3 | [NAME] | Team T-C | [NAME] | 5 | 6 | 3 | 3 | 4 | 4 | 4 | 3 | 4 |  | 27 |  | W
3 | 2010-10-03 00:00:00 | Gypsy Cup 3 | [NAME] | Team K-O | [NAME] | 3 | 4 | 3 | 3 | 5 | 4 | 4 | 5 | 4 |  | 27 |  |  |  | L
3 | 2010-10-03 00:00:00 | Gypsy Cup 3 | [NAME] | Team K-O | [NAME] | 4 | 6 | 7 | 6 | 5 | 6 | 5 | 7 | 4 |  | 27 |  |  |  | L
4 | 2010-10-17 00:00:00 | Gypsy Cup 4 | [NAME] | Team T-C | [NAME] | 4 | 5 | 4 | 5 | 4 | 4 | 3 | 4 | 3 |  | 27 |  | W
4 | 2010-10-17 00:00:00 | Gypsy Cup 4 | [NAME] | Team T-C | [NAME] | 4 | 4 | 3 | 3 | 3 | 4 | 5 | 5 | 5 |  | 27 |  | W
4 | 2010-10-17 00:00:00 | Gypsy Cup 4 | [NAME] | Team K-O | [NAME] | 4 | 4 | 4 | 6 | 4 | 5 | 4 | 5 | 3 |  | 27 |  |  |  | L
4 | 2010-10-17 00:00:00 | Gypsy Cup 4 | [NAME] | Team K-O | [NAME] | 5 | 8 | 11 | 8 | 9 | 9 | 10 | 9 | 9 |  | 27 |  |  |  | L
5 | 2010-10-31 00:00:00 | Gypsy Cup 5 | [NAME] | Team T-C | [NAME] | 3 | 3 | 2 | 3 | 4 | 3 | 4 | 4 | 3 |  | 27 |  | W
5 | 2010-10-31 00:00:00 | Gypsy Cup 5 | [NAME] | Team T-C | [NAME] | 4 | 3 | 6 | 4 | 4 | 3 | 5 | 4 | 4 |  | 27 |  | W
5 | 2010-10-31 00:00:00 | Gypsy Cup 5 | [NAME] | Team K-O | [NAME] | 6 | 6 | 5 | 4 | 3 | 4 | 4 | 2 | 3 |  | 27 |  |  |  | L
5 | 2010-10-31 00:00:00 | Gypsy Cup 5 | [NAME] | Team K-O | [NAME] | 7 | 6 | 5 | 7 | 7 | 6 | 6 | 7 | 5 |  | 27 |  |  |  | L
6 | 2010-11-21 00:00:00 | Gypsy Cup 6 | [NAME] | Team T-C | [NAME] | 4 | 4 | 4 | 5 | 4 | 3 | 3 | 3 | 3 |  | 27 |  | W
6 | 2010-11-21 00:00:00 | Gypsy Cup 6 | [NAME] | Team T-C | [NAME] | 6 | 5 | 4 | 5 | 5 | 4 | 4 | 5 | 5 |  | 27 |  | W
6 | 2010-11-21 00:00:00 | Gypsy Cup 6 | [NAME] | Team K-O | [NAME] | 4 | 4 | 4 | 4 | 4 | 5 | 4 | 4 | 4 |  | 27 |  |  |  | L
6 | 2010-11-21 00:00:00 | Gypsy Cup 6 | [NAME] | Team K-O | [NAME] | 6 | 7 | 7 | 12 | 8 | 7 | 5 | 6 | 3 |  | 27 |  |  |  | L
7 | 2010-11-28 00:00:00 | Gypsy Cup 7 | [NAME] | Team T-C | [NAME] | 4 | 3 | 4 | 4 | 4 | 3 | 5 | 5 | 4 |  | 27 |  | W
7 | 2010-11-28 00:00:00 | Gypsy Cup 7 | [NAME] | Team T-C | [NAME] | 4 | 3 | 5 | 4 | 6 | 3 | 2 | 3 | 7 |  | 27 |  | W
7 | 2010-11-28 00:00:00 | Gypsy Cup 7 | [NAME] | Team K-O | [NAME] | 4 | 4 | 5 | 5 | 4 | 5 | 3 | 4 | 6 |  | 27 |  |  |  | L
7 | 2010-11-28 00:00:00 | Gypsy Cup 7 | [NAME] | Team K-O | [NAME] | 4 | 6 | 5 | 6 | 8 | 5 | 4 | 5 | 6 |  | 27 |  |  |  | L
8 | 2011-02-20 00:00:00 | Gypsy Cup 8 | [NAME] | Team T-C | [NAME] | 4 | 4 | 4 | 3 | 6 | 4 | 5 | 5 | 3 |  | 27 |  | W
8 | 2011-02-20 00:00:00 | Gypsy Cup 8 | [NAME] | Team T-C | [NAME] | 4 | 4 | 3 | 3 | 5 | 5 | 4 | 3 | 3 |  | 27 |  | W
8 | 2011-02-20 00:00:00 | Gypsy Cup 8 | [NAME] | Team K-O | [NAME] | 4 | 4 | 5 | 4 | 7 | 4 | 5 | 3 | 5 |  | 27 |  |  |  | L
8 | 2011-02-20 00:00:00 | Gypsy Cup 8 | [NAME] | Team K-O | [NAME] | 4 | 5 | 4 | 4 | 8 | 6 | 5 | 5 | 5 |  | 27 |  |  |  | L