Forum Discussion

manique's avatar
manique
Copper Contributor
Jan 13, 2023
Solved

Help with IFS

Need an IFS formula for Score of L5 to Populate TSHIRT Size in G5 using my Score rank ranges
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jan 13, 2023

    manique 

    Or simple LOOKUP

    =LOOKUP(L5,ScoreRank,Size)

    if define sizes as

     

mathetes's avatar
mathetes
Silver Contributor
Jan 13, 2023

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. 

Resources