VLOOKUP for a range of numbers
I am looking to try and do a VLOOKUP against a range of numbers versus a single value. The function as I know it today only allows you to look up a value and pull the corresponding value for it (i.e., If the color is Green, then put 2 or if the color is Red, then put the number 3)
In my use case, I am looking at the difference between a start and end date of a project which is a number and then comparing that number to see if resides in a range and giving it a score
Example: The difference between 11/1/2019 and 2/22/2020 is 113 days. Knowing it is now 113, I want to compute that if its between 0-99 give me the value 1, 100-199 give me the value 2, etc.)
I can do this in Excel by referencing a table array and specific column of the score, but in SmartSheet I can't seem to look at more than 2 columns at a given time without getting a #INCORRECT ARGUMENT error
Samples of what I have attached. In this case, I would hope to get a value of 13 as 32 is between 0-179.
Help Article Resources
Check out the Formula Handbook template!