I work for a University in the state of Texas, and one of my
responsibilities is to manage the database for our vehicle fleet.We
have over 200 vehicles in the fleet, so at the end of each month I
generate approximately 1300 entries for our fuel consumption database
and odometer readouts. I was wondering if there is a way to associate
fuel type and vendor information with a unique 12 digit Equipment ID.

For example:
Vehicle 757000206446 always receives unleaded fuel from a commercial
source.
Vehicle 757000213220 always receives diesel fuel from a commercial
source.
Vehicle 757000213276 always receives diesel fuel from an internal
source.

So ideally what i would like, is to type in the ID and have the other
two columns fill themselves in.

So if Column 1 reads 757000206446
Then Column 2 reads Unleaded
and Column 3 reads Commercial

and so on.

The Catch is that my worksheets have to get converted into .csv format
in order to import the data into the database, so to the best of my
knowledge equations will not work, as when a worksheet is exported
into .csv format the text reads out as the equation, not the final
answer.

Any Suggestions?