In Sheets, with amount in D2 and the ascending tier table in H2:I5 (threshold, tier), type the approximate-match lookup that returns the tier.
In Sheets, with amount in D2 and the ascending tier table in H2:I5 (threshold, tier), type the approximate-match lookup that returns the tier.
Answer
=VLOOKUP(D2, H2:I5, 2, TRUE)
TRUE (or omitted) walks down the sorted thresholds and stops at the largest one ≤ D2. 420 → Silver, 1320 → Platinum.