Help with IFS

[manique]

Need an IFS formula for Score of L5 to Populate TSHIRT Size in G5 using my Score rank ranges

[#2]

@manique 

It's not at all clear that you need an IFS formula. 

Instead, what you need is VLOOKUP and a slightly redesigned (inverted, going from low at the top to high at the bottom) Score Rank table. Take a look at this page and see if you can resolve it on your own. If not, come back and ask for help. 

[#3 · Accepted solution]

@manique 

Or simple LOOKUP

=LOOKUP(L5,ScoreRank,Size)

if define sizes as