hi just trying to find a Name based of the score
this is just an example
on my excel sheet its has got much more teams and names so it will take a long time to use IF function
Team 1
Jack, Dave, Mark and Tony
Team 2
Kev, Ste, Mike and Bob
if I want to give 40 to team 1 it should come up...