Excel中的VLookup公式得到错误的答案

I'm trying to get some cells from a column to matchup in one of my sheets, however they get completely different answers than they should. I've made 2 exact same formulas, one which was a test and works, and the other one that I need to get working but doesn't work:I'm trying to get some cells from a column to m