Forum Discussion
New to Excel
Hello, I am trying to rekindle my knowledge of Excel.
Trying to create a table by which you select from Data Validation what power train electric vehicle you would like (Single Motor, SMER, Twin Motor) and for the corresponding data in other cells (i.e. range, battery capacity etc.) automatically populates - I am struggling to find how to create this.
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
