Lookup function giving wrong info

I’m using the lookup function to call up info from a different page. Everything is correct except for the returned value. The columns used for comparison are correct as is the result column itself, just not the specific cell that gets called on. What am I doing wrong?

it would help if you could perhaps show the formula you are using, with some idea of the data you are trying to search.

Pls take a look to the help for verify the correct use.

LOOKUP HELP