Maybe Tony was correct after all....
A
B
1
 Team
2
 aa
1.9
3
 bb
0.8
4
 cc
2.1
5
6
 bb
7
0.8

A7=VLOOKUP(A6,$A$2:$B$4,2,0)