approximate value and not the exact value

[marreco]

Hi.
I need a function that returns me the approximate value and not the exact value.
example:

Number	value next sought	result
3	33	32
2
6
32
33
45

<tbody>
</tbody>

33 if I type in 'B1' and my mother I'm 33 and I have a number near and less than the number entered in 'B1' will be returned 32

thank you!!

 

[Cutter]

Alternative

=VLOOKUP(B1-ISNA(MATCH(B1,A2:A14,0)),A2:A14,1,1)

 

[Cutter]

Alternative to alternative

=LOOKUP(B1-1,A2:A14)