Forum Discussion
New to Excel
try this,
Step1: Prepare the data ( i assume you already have)
power train | Range | Batter Capacity | Acceleration |
| Single Motor | 250 | 75 | 6.5 |
| SMER | 300 | 90 | 4.8 |
| Twin Motor | 320 | 100 | 3.5 |
Step2: Create a drop down list using data validation
1.select the cell where you want the dropdown list (eg.A10)
2.go to the Data tab an click on Data Validation
3.in the Allow box, select List
4.in the Source box type the range where your power tran optiosn are listed For example
=$A$2:$A$4
5.Click ok
Step3: Use VLOOKUP OR XLOOKUP Auto-Populate Data
To-Atuomatically fill the data based on the selected power train
1.Select the cell where you want the range to appear (e.g: B10)
2.Enter the following formula
=vlookup($A$10, $A$2:$D$4, 2 , FALSE)
.$A$10 - The selected powertrain
.$A$2:$D$4 - the table range
.2-The column number for the range
FALSE - Exact match
3. Repeat the process for other cells
Step4: Test your table
1.Select the power train fro mthe drop down
2.Check if the corresponding data populates automatically in the adjascent cells