Darren1593
New Member
- Joined
- Aug 28, 2019
- Messages
- 9
Hi, i am looking for a formula to auto fill in the MOTM box in sheet 2 (bottom image) when i write the name in sheet 1 i would like it to auto populate in sheet 2 with a number. I already use a formula for the scorers =SUMIF(Sheet1!C$2:C$9997,B15,Sheet1!D$2:D$9997)
hope someone can help and i made sense
hope someone can help and i made sense