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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!