excel - Select value from list based on value in cell -

i trying select value range of values, based on number entered in cell. assume have following data available:

1   308.331 2   292.363 3   289.582 4   294.610 5   300.468 6   298.427 7   292.433 8   293.646 9   282.613 10  293.143 

(note data inside same excel-sheet.)

if enter number 10 cell a1, how can display value number 10 293.143 displayed a2?

i have been looking @ complex if statements doesn't seem correct way go. there of select from function available in excel?

you need use vlookup() ... https://support.office.com/en-ca/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1

assuming following layout ...

put cell e1 ...

=vlookup(d1, $a$1:$b$10, 2, false) 

note use of 4th parameter false ... looks exact match.