Try
=LOOKUP('Vehicle Inspection'!A2,{"A","B","C","D","E","F","G","H"},'Vehicle Inspection'!C2:C9)