I'm checking a value against a table, I need behavior like a VLOOKUP table except I wan't to take the value less than the table value.

For example, I have a value, say 230. I want to look up which of these its closest to, but less than:

1 110
2 220
3 340
4 460
5 503
6 620
7 700
8 890
9 910
10 1120



So I wan't to return "3", as its less than 340. I can't use VBA. Does anyone know how I can do this?

Cheers