wrong results for Lookup function

[Brody15]

I've been having issues with Lookup function in excel. It seems to work for some rows but won't work for 2 out 4 rows. I appreciate if someone could help me with it. Thanks in advance.
=LOOKUP(B6,$A$16:$A$19,$B$16:$B$19)

 

[Joe4]

Welcome to the Board.

Your attempt to post an image did not work.

There are tools available you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

 

[Aladin Akyurek]

A16:B19 must be sorted in ascending order for LOOKUP to work.

Maybe you are intending this?

=VLOOKUP(B6,$A$16:$B$19,2,0)