I am not sure the right terminology to use to create the formula I am trying to write.
I have a table with headings "Lower" "Upper" and "Return"
What I want to create is basically to look at a value say in cell B2 and then determine where that value lies in the table (comparing it against the Lower number, and the Upper Number), and then in Cell B3 have it return the value in the Return column.
Essentially
Lower <= Input < Upper
But Just trying to do it cleaner than a long drawn out If/Then.
Bookmarks