Determining what range a value in one table fits in based on a second table

Neil-HawaiianAir

Hello,

I suspect this is some sort of looping workflow but I'm not sure how to set it up.  I have a table with a list of Items and Values.  I want to compare the values in this table to ranges in another table and return the results.  I have attached an Excel file that has the Items in one tab (Items), the Ranges in another (Ranges) and the Results in a third (Results).

Any suggestions would be appreciated.

Neil

Example.xlsx

DavidP

Hi @Neil-HawaiianAir 

Here's a quick and easy way to do it with a Generate rows tool

match values to ranges.yxmd