Since the points are sorted you can use the below. With your data in ColA and B

=VLOOKUP("admin697",A:B,2,0)

or with username in cell C1
=VLOOKUP(C1,A:B,2,0)

If this post helps click Yes
---------------
Jacob Skaria


"Halin" wrote:

If I would like to know lowest point of each user, what function that I can
use?

User Points
9cats999 1180
1200
acc00995 1040
1070
1200
accou996 1200
admin475 1040
1070
admin697 1200
1690
adminasa 2220
2230

Thanks