I have a huge dataset with income brackets in column B and BMI values in column C:

```
totinc BMI
15600>18200 19.5
18200>20800 27.4
20800>23400 22
23400>26000 29.5
```

And so on. What formula can i use to order this data by the total income group for example assigning number 1 in column A to those in the 15600>18200 group etc

I have tried using a VLOOKUP formula but it only works when i use one number and no with the > or < symbols and i do not have time to change the values.

Any help would be greatly appreciated,

Sam