How to lookup data and round down to the lower of the return results if the lookup value falls in betwween the values in the lookup column

[wpyles]

I have a table full of values that I want to look up in a table like below (incomplete data set just for iillustration):

Aggregate Industry Equivalent Unit Score	Industry Diversity Score
0	0
0.05	0.1
0.15	0.2
0.25	0.3
0.35	0.4
0.45	0.5
0.55	0.6
0.65	0.7
0.75	0.8
0.85	0.9
0.95	1
1.05	1.05
1.15	1.1
1.25	1.15
1.35	1.2
1.45	1.25
1.55	1.3
1.65	1.35

<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY>
</TBODY>

If the value I am looking up falls in between any of the values in Column A above (Aggregate Industry Equivalent Unit Score), I want it to return the applicable lower value from Column B (Industry Diversity Score) of the two numbers that it falls in between. For example, the results would be:

Aggregate Industry Equivalent Unit Score	Industry Diversity Score
0.54	0.5
0.26	0.3
0.049	0
1.061	1.05
0.96	1
0.275	0.3
0.585	0.6
1.315	1.15
1.315	1.15

<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY>
</TBODY>

Is there are good formula trick for this?

Thank you.

 

[sergioMabres]

Hi wpyles,
Yes you can use =VLOOKUP(D2,$A$2:$B$19,2,1)
When the last parameter is set to true (in this case 1) it works like you need/described
Cheers
Sergio