Look to see if value falls between two values and return correct group name

This is for a power query. In my main table I have a column of numeric values called Field. In a small lookup table (5 rows) I have 3 columns, the first column is the group name, the second is the minimum value, the third the maximum value. I would like to return a new column called GroupName in my main table where the Field value is between the min and max value in the lookup table and returns the corresponding group name.