Lookup closest value

[cmb80]

Hi All, I have a table as below

0.75 0
1 3
1.25 4
1.5 5
1.75 7
2 8
2.24 9
2.5 11
2.75 12
3 14
3.25 15
3.5 16


I need to lookup values against the first column, and return the value in teh second. HOWEVER some of the values I want to lookup are not exact matches.

In these instances I want the value to round down and lookup the corrosponding figure.

So for instance, if I wanted to lookup value 2.22, it would produce the answer 8. (As it would round down to 2). If the lookup value was 2.26, it would produce 9.

I know this is possible, I'm just getting tangled up trying to do it.

[daddylonglegs]

If your table is in A1:A12 and lookup value in C1 try

=LOOKUP(C1,A1:B12)

[cmb80]

Simple but effective - thanks