Is it possible??

  • Thread starter Thread starter Daishido4me
  • Start date Start date
D

Daishido4me

I am trying to create a new vehicle log for my work place. I want to be able
to enter a vehicle number like 008 and have the name, and type of vehicle to
automatically fill out on the worksheet. Is that possible and how would I go
about doing it. Many thanks
 
I am trying to create a new vehicle log for my work place. I want to be able
to enter a vehicle number like 008 and have the name, and type of vehicle to
automatically fill out on the worksheet. Is that possible and how would I go
about doing it. Many thanks
Click to expand...

One way of doing this is to have a data table where the translations
from number to name and type are stated and then use the VLOOKUP
function.

Exampel:
Column A contains the numbers
Column B contains the names corresponding to each number
Column C contains the types corresponding to each number

Cell D1 contains a vechicle number
Cell E1 is where you want the vehicle name
Cell F1 is where you want the vehicle type

In cell E1 you put the formula
=VLOOKUP(D1,A1:C100,2,FALSE)

In cell F1 you put the formula
=VLOOKUP(D1,A1:C100,3,FALSE)

Change the 100 to fit the size of your data table in columns A to C

You can "hide" the data table either by hiding columns A to C or
putting the table in another worksheet.

Hope this helps / Lars-Åke
 
Back
Top