Help with IFS

Occasional Visitor


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

2 Replies


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. 

best response confirmed by manique (Occasional Visitor)


Or simple LOOKUP


if define sizes as