Forum Discussion
Selecting a value by determining if a number lands between two values on a scale
You may use formula like
=INDEX($K$2:$K$40,MATCH(1,INDEX(($D2>=$I$2:$I$40)*($D2<=$J$2:$J$40),0),0))
Please see attached
Thank you again for your guidance! Leveraging User Defined Functions in the future will certainly be a valuable asset while trying to refine this old spreadsheet into a more useful tool. I will have to experiment if there are any adverse conditions created by converting the main workbook into a macro enabled version. Currently the macros I created through the record macro function run with buttons added to the quick access - I was unaware of the different version of the spreadsheets. Being able to build them into the book itself seems like something that might be a good quality of life change.
Another solution that was recommended was use of the lookup function. In this case this function copied down:
=LOOKUP(D2,$I$2:$I$22,$K$2:$K$22)
I sincerely appreciate your guidance!
You may use formula like
=INDEX($K$2:$K$40,MATCH(1,INDEX(($D2>=$I$2:$I$40)*($D2<=$J$2:$J$40),0),0))
Please see attached