I have a table with three columns A,B,C, the first column is the value I’d like to get returned from the formula I need help with. The second and third column contain starting and ending number ranges. I have searched and played with all kinds of ideas but have not been able to figure out a solution. I can’t use a nested if-then because unfortunately I have over 150 rows with beginning and ending integers and that would not work.
The Problem: If a value falls between one of the range pairs in my table I’d like the lookup formula on a differnt tab to return the value from column A.
Return Value, Starting Number, Ending Number
A- 001-010
B- 855-897
C- 151-156
D- 243-312
E- 313-323
F- 1,224-1,244
Example:
5 with the "=Lookup formula" would return "A", 244 would return "D", 880 would return "B" and so on. I attached an example table with data for better reference. Any help is much appreciated!
Bookmarks