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