G'day All,
I have a table of scores, player numbers, players, teams.
I want to lookup the lowest scoring player from each team using the same
formula.
i.e.(in csv format)
1,6,John,Red
2,4,Pete,Blue
3,2,Nick,Red
4,9,Andy,Green
5,3,Bruce,Blue
6,5,Frank,Green

In the example I would want to return 4 for Blue team.
The scores are in asending order, so the first occurance of the lookup_value
will return the lowest score.
I would have used vlookup but the look up value is on the right not left of
the table_array.

Thanking you in anticipation,
build