Range Lookup

[Thomas Kuriakose]

Respected Sirs,

Good day to you.

I am trying to lookup up a speeds and categorize them to specific ranges (G2:G6) in the attached workbook.

The results are matching for some of the ranges but not for he below ranges -

1. 0.2-0.63 if the speed equal to 0.63. Based on the lookup formula it is giving this in range 0.64-1.2
2. 1.3-1.6 if the speed equal to 1.6.Based on the lookup formula it is giving this in range >1.6

Kindly guide on how to get the results correctly.

Thank you very much,

with regards,
thomas

 

[AliGW]

Change the formula to this:

=LOOKUP(A2,{0,0.2,0.64,1.3,1.7},Table1[Speed])

Each value stated in the lookup array needs to be the first value in the range.

 

[Thomas Kuriakose]

Respected Mam',

Thank you very much for the correct solution and this insight.

Much appreciated,

with regards,
thomas

 

[AliGW]

You're welcome!

Have a nice day - I'm just out into the garden to enjoy the very warm sunshine.