Return value if cell value is in between 2 numbers

Hi all,

I want to create a formula that automatically converts wind speed (km/h) into a number on the Beaufort scale.

I have some measurements of wind speed in km/h in cell A1 to A8:

20,3
35,9
27,8
20,6
40,0
19,9
20,6
27,9

How can I make sure in cell B1:B8 that if the value:
A < 1 => B = 0
1 < A < 5 => B = 1
5 < A < 11 => B = 2
11 < A < 19 => B = 3
19 < A < 28 => B = 4
28 < A < 38 => B = 5
38 < A < 49 => B = 6
49 < A < 61 => B = 7
61 < A < 74 => B = 8
74 < A < 88 => B = 9
88 < A < 102 => B = 10

Thanks !

Looks to me like a "standard" lookup table + lookup function combination using the "approximate match" binary search option (4th argument of VLOOKUP()=TRUE). Unfortunately, almost all of the examples across the internet are for "exact match" lookups. I have an example here that illustrates the behavior of the approximate match lookup: https://www.excelforum.com/tips-and-...p-example.html

1) Put your "lower bound" values into a column (0,1,5,12,...). Enter the associated Beaufort scale number in an adjacent column (to the right, if you are going to use VLOOKUP()) (0,1,2,3,...)
2) Use a formula like =VLOOKUP(windspeed,absolute reference to lookup table from step 1,2,TRUE) where you want to return the Beaufort scale result.

Unless there is something I am missing, it should be that easy.