Hello experts, I am struggling with this formula again. Please kindly help if
you can. Thanks much!

I need to get award values based on thresholds, but same user will only get
non-repeated awards. Here is the award lookup table:
100 - A,
250 - A, B
500 - A, B, C

Sample data looks like this: I need help with formula for award. Thanks much!!
ID Data Award
1 50
1 105 A
1 307 B
2 250 A, B
2 350
2 505 C