If Cell Value = Value in Column A then Display Column Header OR Etc

[Leesa]

I have 6 categories (Jumbo, Extra Large, Large, Medium, Small, PeeWee) which each have select ranges (Jumbo = 2.42 - 2.18, Extra Large = 2.17 - 1.93, Large = 1.92 - 1.68, Medium = 1.67 - 1.43, Small = 1.42 - 1.18, PeeWee = 1.17 - 0.00)

I have a list in the H column of different values, Ex: H5 = 2.04, H6 = 1.98, H7 = 2.08, etc.

I want the I column next to the H Values to tell me if that value meets the requirements to be Jumbo, Extra Large, Large, etc.

I am not sure how best to do the logic formula so it will display correction. I have placed a value chart for the sizes on a different part of the spreadsheet as a reference. I do not know all the formulas but I know there is a way to do this…please help!

[robleyd]

Perhaps the VLOOKUP function is what you need.

[EarnestAl]

Sample using @robleyd suggestion
MeasuredToSize.ods (8.1 KB)

[JohnSUN]

In addition to the solution of dear colleagues @robleyd and @EarnestAl, a small note: since the table of category and size correspondences will not change (in any case, it will not change very soon), you can enter all these values directly into the formula:

=LOOKUP(H2;{0|1.18|1.43|1.68|1.93|2.18};{"PeeWee"|"Small"|"Medium"|"Large"|"Extra Large"|"Jumbo"})

This will allow you not to maintain a separate sheet for the reference table. If the formula is used frequently, put it in a named formula expression, for example, get_Category and use it in the right places like =get_Category