Excel: lookup vector is ascending but retus wrong value

I've created a scoring system that I want to use to compare individual values to, but some values are not retuing correctly.

For example; compare the value 2.15 to the scoring range below:

0.00-0.03=1,
0.04-0.19=2,  
0.20-1.05=3,
1.06-2.06=4, 
    >5.87=5

Formula:
=LOOKUP(2.15,{0,0.04,0.20,1.06,5.87},{1,2,3,4,5})

The value retued is 4, but 2.15 should fall in the 5th category.

How should I write the lookup vector?

Recent Questions...