I am working on a spreadsheet that seeks to collate scores to a team. There is an input table where team and score start next to each other (see the example sheet linked below) into a table with each teams (multiple) score next to it.
What is the best method to lookup for the second and later time a team appears in the raw score, since VLookup only returns one of the values from the list? Or barring a solution to that, is there an easier method to take all values that are associated with another and form a new table?
Here is the link: Score Lookup