If you have one cell, or you need to drag this formula down or Flash Fill a column in a defined data Table, this formula will work:

=XLOOKUP(K9,$H$4:$H$7,$G$4:$G$7,"Bigger than 150",1)

K9 is the single sell value in question.

The lookup array is the Max Length data.

The Return Array is the Group Numbers.

If the size is larger than 150, this is stated - in the 'if not found' part of the formula.

The match mode is 'exact match or next larger item'.

The 'search mode' is not specified, but by default is first to last.

The last 3 parts of the formula are optional, but, in this example the first 2 of these do need to be specified.