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
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