Help find value

[wydn]

Hello
I am a beginner in excel
i need help to find the closest value in the columm
i.e i have data in cell A1:A5
1200
1345
1400
1540
1898

i have value 1900 in cell A7 and i wanna find the closest value.
the closest value is 1898
how can i get it and place it in cel A8

Thanks for the help!!!

 

[VoG]

Try

=INDEX(A1:A5,MATCH(A7,A1:A5,1))