between IF functions

[FGm496]

In the worksheet i made, cell B10 looks at the chart to the right and either says it's high, low, or one of the exact values. But what i would like to do is have it also look at the numbers in between each value. So the program can find x and z (exact values from the chart) but it can't find x<y<z (in between numbers).
So how can i get that work. And if anybody can improve anything, that would be helpful too.

FYI it's protected, so you'll just have to unprotect it, and i have some of the math whited out on the right, so just make the text black again to see that stuff.

[MarvinP]

Hi FGm496 and welcome to the forum.

You want the VLookup formula that isn't exact. See what I've done with your formula. You will need to have your table sorted, which you do have.

Read about VLookup and see why this works for you.

[FGm496]

Thanks you for the quick reply, that fixed it.