Spreadsheet: 837554d1690236769-excel-non-vba-code-create-a-formula-that-looks-up-multiple-values-total-team-score-formula-error-2
Sheet: Sheet1

Determine Team Score
Goal: Determine total team score (in a number of cases there may only be 2 or 3 players in the Team)
 | Player Sign Up Sheet
 | BOWMAN, SCOTT | OTOOLE, [NAME] |  |  |  | Individual Score Sheet
 | PATRICK, TJ | WILLEMS, JULE | COOK, RON | GOLDSTEIN, PAUL |  | Player | Flight | Hcp | Gross Score | Net Score
 | RODBERG, STEVEN | AHRENS, STEVE | PETERSON, TOM | JONES, BILL |  | ADGATE, STEVE | B | 22
 | NOWAK, BOB | LECHER, MARK |  |  |  | AHRENS, STEVE | A | 19 | 85 | 66
 | HAYDEN, JACK | LEWIS, [NAME] | WENTHUR, CURTIS | SCHULTZ, RIC |  | ANZIA, RONALD | B | 24
 |  |  |  |  |  | BAIL, PHIL | E | 35 | 107 | 72
 | Score |  |  |  |  | BARTHOLOMEW, BOB | A | 20 | 85 | 65
 |  | =[NAME])) |  |  |  | BAUZENBERGER, RICHARD | B | 21 | 81 | 60
 |  |  |  |  |  | BAZAN, [NAME] | D | 30 | 93 | 63
 |  |  |  |  |  | BERGER, DAVE | D | 33
 |  |  |  |  |  | BEWALDA, BOB | C | 26 | 88 | 62
 |  |  |  |  |  | BISHOP, DAVE | A | 20 | 81 | 61
 |  |  |  |  |  | BISHOP, REB | C | 28 | 96 | 68
 |  |  |  |  |  | BOESELAGER, JEROME | B | 22
 |  |  |  |  |  | BOWMAN, SCOTT | B | 25 | 93 | 68
 |  |  |  |  |  | BURGHARDT, CHIP | E | 38 | 104 | 66
 |  |  |  |  |  | BURKHARDT, [NAME] | B | 25 | 86 | 61
 |  |  |  |  |  | CALVELLI, RICK | E | 37
 |  |  |  |  |  | CAMPBELL, [NAME] | C | 27
 |  |  |  |  |  | CHRISTENSON, ERIK | E | 45
 |  |  |  |  |  | CHRISTL, DON | N |  | 97
 |  |  |  |  |  | CONDELLA, VINCE | A | 19 | 80 | 61
 |  |  |  |  |  | COOK, RON | C | 26 | 93 | 67
 |  |  |  |  |  | CZECH, TOM | E | 44 | 96 | 52
 |  |  |  |  |  | DAVIS, JULIUS | D | 30 | 104 | 74
 |  |  |  |  |  | D'CRUZE, [NAME] | E | 40
 |  |  |  |  |  | DEVEREY, PETER | B | 24 | 96 | 72
 |  |  |  |  |  | DINESEN, NIEL | E | 45
 |  |  |  |  |  | DIVINE, [NAME] | D | 31
 |  |  |  |  |  | EDWARDS, [NAME] | E | 41 | 112 | 71
 |  |  |  |  |  | FLYNN, BILL | C | 28 | 100 | 72
 |  |  |  |  |  | GASPERIC, [NAME] | D | 31
 |  |  |  |  |  | GILROY, BOB | C | 27
 |  |  |  |  |  | GIULIANI, [NAME] | C | 27
 |  |  |  |  |  | GOLDSTEIN, PAUL | D | 31 | 102 | 71
 |  |  |  |  |  | HANNEMANN, [NAME] | A | 18 | 87 | 69
 |  |  |  |  |  | HAYDEN, JACK | B | 25 | 90 | 65
 |  |  |  |  |  | HEATWOLE, SCOTT | D | 32 | 105 | 73
 |  |  |  |  |  | HITLER, PETER | C | 29 | 95 | 66
 |  |  |  |  |  | HOCKINSON, JACK | E | 38 | 103 | 65
 |  |  |  |  |  | HOLTORF, SCOTT | B | 22
 |  |  |  |  |  | HOMAN, MARK | C | 28 | 93 | 65
 |  |  |  |  |  | INMAN, STEVE | D | 34 | 97 | 63
 |  |  |  |  |  | [NAME], RICHARD | B | 23
 |  |  |  |  |  | [NAME], [NAME] | E | 37 | 112 | 75
 |  |  |  |  |  | JARR, RON | C | 26 | 92 | 66
 |  |  |  |  |  | [NAME], JJ | E | 43
 |  |  |  |  |  | JONES, BILL | A | 13 | 80 | 67
 |  |  |  |  |  | [NAME], JAY | D | 30
 |  |  |  |  |  | KEEN, JOHN | D | 32 | 106 | 74
 |  |  |  |  |  | KING, RICK | A | 19 | 90 | 71
 |  |  |  |  |  | KLEIN, [NAME] | E | 38 | 106 | 68
 |  |  |  |  |  | KNOECKLEIN, MAX | E | 45 | 128 | 83
 |  |  |  |  |  | KOESTER, KIPP | C | 26
 |  |  |  |  |  | LAKE, JIM | D | 31 | 97 | 66
 |  |  |  |  |  | LANGE, [NAME] | D | 34 | 93 | 59
 |  |  |  |  |  | LECHER, MARK | A | 19 | 85 | 66
 |  |  |  |  |  | [NAME], [NAME] | B | 21
 |  |  |  |  |  | LEWIS, JIM | A | 17
 |  |  |  |  |  | LEWIS, [NAME] | E | 44 | 104 | 60
 |  |  |  |  |  | LILYQUIST, [NAME] | A | 19 | 89 | 70
 |  |  |  |  |  | LOHR, CHUCK | A | 18
 |  |  |  |  |  | LORENZ, [NAME] | B | 21 | 96 | 75
 |  |  |  |  |  | MADRITSCH, BOB | A | 15 | 90 | 75
 |  |  |  |  |  | [NAME], [NAME] | C | 26
 |  |  |  |  |  | MARTIN, [NAME] | N |  | 95
 |  |  |  |  |  | MCELROY, DAN | D | 31
 |  |  |  |  |  | MCKNIGHT, KERRY | E | 42 | 110 | 68
 |  |  |  |  |  | MEDTLIE, PEDER | C | 27 | 90 | 63
 |  |  |  |  |  | MEEUSEN, GARY | D | 32
 |  |  |  |  |  | MICHAUD, [NAME] | B | 23
 |  |  |  |  |  | MOYER, JACK | B | 24 | 87 | 63
 |  |  |  |  |  | NICOUD, [NAME] | A | 19
 |  |  |  |  |  | NOWAK, BOB | C | 28 | 97 | 69
 |  |  |  |  |  | OLSON, [NAME] | E | 45
 |  |  |  |  |  | O'MALLEY, TOM | D | 31 | 100 | 69
 |  |  |  |  |  | OTOOLE, [NAME] | A | 18 | 90 | 72
 |  |  |  |  |  | PATRICK, TJ | A | 14 | 82 | 68
 |  |  |  |  |  | PETERKA, PATRICK | D | 34 | 97 | 63
 |  |  |  |  |  | PETERMAN, STEVE | D | 30 | 95 | 65
 |  |  |  |  |  | PETERSON, TOM | A | 16 | 83 | 67
 |  |  |  |  |  | POSSLEY, ROBERT | D | 31
 |  |  |  |  |  | REILLY, [NAME] | E | 40 | 98 | 58
 |  |  |  |  |  | RICHMOND, JOHN | N
 |  |  |  |  |  | RITT, DON | B | 23 | 89 | 66
 |  |  |  |  |  | RODBERG, STEVEN | B | 23 | 82 | 59
 |  |  |  |  |  | ROGAHN, GARY | B | 22 | 92 | 70
 |  |  |  |  |  | SAPORITO, JON | B | 23 | 89 | 66
 |  |  |  |  |  | SCHLAEFER, STEVE | B | 22 | 96 | 74
 |  |  |  |  |  | SCHLIESLEDER, JIM | C | 29 | 94 | 65
 |  |  |  |  |  | SCHULTZ, RIC | C | 29 | 95 | 66
 |  |  |  |  |  | SCHUTZ, TOM | A | 16
 |  |  |  |  |  | SCHWENSOHN, HERB | A | 19 | 91 | 72
 |  |  |  |  |  | SCHWULST, [NAME] | E | 45
 |  |  |  |  |  | SHEEHAN, BOB | E | 42 | 119 | 77
 |  |  |  |  |  | SINGLEY, BILL | C | 27 | 92 | 65
 |  |  |  |  |  | SMITH, [NAME] | E | 35
 |  |  |  |  |  | SOLYMOSSY, STEVE | C | 26 | 84 | 58
 |  |  |  |  |  | STERN, JIM | D | 34 | 105 | 71
 |  |  |  |  |  | STOCK, LEE | E | 45 | 117 | 72
 |  |  |  |  |  | STUMPF, GLEN | B | 24
 |  |  |  |  |  | SWANSON, CLINT | D | 31 | 92 | 61
 |  |  |  |  |  | SWISHER, ROY | E | 36 | 105 | 69
 |  |  |  |  |  | THOMPSON, LARRY | C | 28 | 87 | 59
 |  |  |  |  |  | TOCK, [NAME] | A | 10
 |  |  |  |  |  | TONELLI, JIM | A | 18
 |  |  |  |  |  | UNGERMAN, RICK | C | 26 | 104 | 78
 |  |  |  |  |  | VOLLMER, [NAME] | C | 29 | 104 | 75
 |  |  |  |  |  | WAGNER, JIM | D | 32 | 97 | 65
 |  |  |  |  |  | WALLIS, [NAME] | B | 22 | 86 | 64
 |  |  |  |  |  | WENTHUR, CURTIS | A | 18 | 88 | 70
 |  |  |  |  |  | WESTER, [NAME] | B | 23
 |  |  |  |  |  | WHAM, ROBERT | C | 28
 |  |  |  |  |  | WILL, TREVOR | A | 12 | 77 | 65
 |  |  |  |  |  | WILLEMS, JULE | B | 25 | 89 | 64
 |  |  |  |  |  | WITHAM, [NAME] | B | 25 | 89 | 64
 |  |  |  |  |  | ZIPTER, [NAME] | B | 24 | 86 | 62
 |  |  |  |  |  | ZITO, BILL | E | 41
 |  |  |  |  |  | HERRO, JIM | N |  | 102