LOOKUP feature only putting info of first line can someone help

[appteam6]

I am using a lookup feature but I know everything looks good but when I run the form it pulls the information from the top of the data table and doesn’t actually do a lookup.

Here is my formula
LOOKUP([6 Digit Car Code], “Most Recent Status”, “6 Digit Car Code”, “Miles”)

I am typing that 6 digit car code into another line and when it does the lookup it pulls the first line in the data table. It is not doing the lookup at all.