New to Excel

try this,

Step1: Prepare the data ( i assume you already have)

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