I have a range of numbers which I need to compare against a table to determine an output. So, for example the table has 7 different options, less than 1000 (equals 1), between 1001-2000 (equals 2), between 2001-3000 (equals 3), etc and so when we input numbers, for example 2431, the output would automatically determine the answer is 3.
I know its a lookup but I dont know how to do a range lookup. I could just do a huge IF formula but I know there is a better way.
I have attached the spreadsheet im working so it is clearer and perhaps the solution can just be put directly into the spreadsheet.