Spreadsheet: 78426d1278773522-formula-that-automatically-uses-the-last-cell-in-a-row-book1-lookup-issue
Sheet: score-team sheet

 |  | # PLAYERS: | 0 | FRONT 9 = | 0 |  |  | # Players in Skins = |  | 0 |  | GROSS Skin Pot = |  |  | 0 |  |  | EA Gross Skin Worth = |  |  |  | #[NAME]! |  |  | TOTAL $$ COLLECTED: |  |  |  | 0
 |  | GAME POT: | 0 | BACK 9 = | 0 |  |  | # [NAME] = |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EA = | #[NAME]! | Score sheet:
 |  |  |  |  |  |  |  |  | SKIN SCORE>> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | [NAME]: =VLOOKUP(A10,'player info'!A3:D9,3,FALSE)
 |  |  | BLUE | WHITE | GREEN |  |  |  | Hole>> | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  |  | G10: =VLOOKUP(A10,'player info'!A3:D9,4,FALSE)
 |  |  | 135 | 132 | 128 |  |  |  | Par>> | 4 | 4 | 5 | 3 | 4 | 3 | 4 | 4 | 5 |  | 4 | 5 | 3 | 4 | 4 | 3 | 4 | 5 | 4
 |  |  | B | W | G |  |  |  | HDCP>>> | 3 | 15 | 7 | 11 | 5 | 17 | 9 | 1 | 13 |  | 8 | 10 | 18 | 6 | 2 | 12 | 4 | 14 | 16
ID# |  |  | TEAM NAME / PLAYERS |  | TEES | INDEX | PTS | [NAME] | GROSS SCORE |  |  |  |  |  |  |  |  |  | OUT |  |  |  |  |  |  |  |  |  | IN | TOTAL
7 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
2 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
3 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
4 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
6 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 | 0 | 0 | 0 | <<POINTS |  | 0 | 0 | <RESULTS>
 |  | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 | 0 | 0 | 0 | <<POINTS |  | 0 | 0 | <RESULTS>
 |  | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 | IFERROR(VLOOKUP($A10,'player info'!$A$3:$D$9,COLUMN()-2,FALSE),"") drag down |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 | IFERROR(VLOOKUP($A10,'player info'!$A$2:$D$9,COLUMN()-3,FALSE),"") drag over to G10 and down |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 | 0 | 0 | 0 | <<POINTS |  | 0 | 0 | <RESULTS>
 |  | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 | 0 | 0 | 0 | <<POINTS |  | 0 | 0 | <RESULTS>
 |  | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 | 0 | 0 | 0 | <<POINTS |  | 0 | 0 | <RESULTS>
 |  | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 | 0 | 0 | 0 | <<POINTS |  | 0 | 0 | <RESULTS>
 |  | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 | 0 | 0 | 0 | <<POINTS |  | 0 | 0 | <RESULTS>
 |  | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 | 0 | 0 | 0 | <<POINTS |  | 0 | 0 | <RESULTS>
 |  | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 | 0 | 0 | 0 | <<POINTS |  | 0 | 0 | <RESULTS>
 |  | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 | 0 | 0 | 0 | <<POINTS |  | 0 | 0 | <RESULTS>