Self teacher

[D a v e]

I am very new to computers and maybe moving to fast. I don't even know what people are talking about most of the time until i research it. But i love a challenge and love what i read about what excel can do. So anyway I know what I want and I got part of it by using the if function but couldn't figure out the last few cells or how to continue the function when I changed the driver # since all 40 drivers are going to be using the same cells. So here goes. My main cell will have a drop down list with lets say 40 drivers. So when I bring up driver # 730 from there I need a function that will fill these cells with this info. For this example my drop down list is in cell A3
A C E G I
1. Driver # Driver Name Type Vehicle Fuel Type Driver/Owner
2.
3. 730

So if A3 = 730 then C3 is Charlie, E3 is Dock High, G3 is Diesel, I3 is Owner.
For A3 there is roughly 40 choices that the rest of the cells would change depending on what driver # was selected.. C3 is 40 different names. E3 Would either be Dock High, Cube, Sprinter, or Van. G3 would either be Diesel or Unleaded.and I3 would be Owner or Driver.

 

[VoG]

Hello. You could create a table of your drivers and their attributes then use VLOOKUP to return the information from that table.

Here's a (randomly selected) tutorial Excel Lookup & Reference Functions - Easy Excel Tutorial

 

[Comfy]

Hi Dave,

Welcome to the board.

You will need to store this information in a Lookup Table so Excel knows which values to display when you pick a driver.

Here's an example of the Table:

Excel 2010
	A	B	C	D	E
1	Driver	Driver Name	Type Vehicle	Fuel Type	Driver/Owner
2	1	Dave	Dock High	Diesel	Owner
3	2	Mary	Dock High	Petrol	Driver
4	3	Steve	Dock High	Diesel	Driver
5	4	Jo	Dock High	Petrol	Owner
6	5	Hannah	Dock High	Petrol	Driver
Lookup Details

Then you can use a Function called VLOOKUP to display this information in your 'main' sheet based on the driver number that you select:

Excel 2010
	A	B	C	D	E	F	G	H	I
2	Driver		Driver Name		Type Vehicle		Fuel Type		Driver/Owner
3	1		Dave		Dock High		Diesel		Owner
Sheet1

Cell Formulas
Range	Formula
C3	=VLOOKUP($A3,'Lookup Details'!$A$1:$E$6,2,FALSE)
E3	=VLOOKUP($A3,'Lookup Details'!$A$1:$E$6,3,FALSE)
G3	=VLOOKUP($A3,'Lookup Details'!$A$1:$E$6,4,FALSE)
I3	=VLOOKUP($A3,'Lookup Details'!$A$1:$E$6,5,FALSE)

 

[D a v e]

Well thank you so much for adding the examples. It really helps out alot when you don't understand exactly what it is everyone refers to. And I want to learn so it's alot of reading watching and and the best part of all trial by error.

 

[D a v e]

Thanks a bunch. I will check it out.