Linking Attributes

[Allan Kahn]

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?

 

[Vacuum Sealed]

Hi Allan

You could have a 2 pronged approach to this.

1. Name Sheet.1 as Data Input.

your 1st column could be converted to a Validated List and then
you can populate your other 2 columns using a lookup table.

example:

=IF(I6="","",(LOOKUP(I6,INFO!$H$2:$L$132,INFO!$I$2:$I$132)))


2. Name sheet.2 as Data Export

After you have finished inputting the information, copy the range you
require, then PasteSpecial.Values into here and export this into your .CSV
File.

Check out Debra Dalgliesh's website for some really good examples of Data
Validations and lookups.

http://www.contextures.com/xlDataVal08.html

HTH
Mick