I have a row of data that I want to grab based on a single cell of data.

say my cell A1 = 5

I then have many rows of data in another worksheet:

8 | 100
7 | 93
6 | 73
9 | 32

since there is no value for "5" in any of the rows, I want to return the closest value to 5 (6). how do i do this?