and the i have another table with these fields in them
Why? This sounds like you're off on the wrong foot, especially when you bring Excel knowledge into the picture. That's usually a bad thing when it comes to relational databases. The pk field of the vehicle table should be related to other tables - f'rinstance, the table that holds records for maintenance. Suggest you research database normalization.
Ignoring all that, an Excel-like lookup in Access is DLookup.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.