Auto Population-- using pivot table

Is there a way to auto populate a field (cells) when you click on a drop down list item?

Please see sample.

Thank you,

Try these:

I4 =IFERROR(INDEX(Table1[Oil changes per year],MATCH(J4,Table1[Vin'# ],0)),"")
J4 =IFERROR(INDEX(Table1[Vin'# ],SMALL(IF(Table1[Oil changes per year]=I$2,ROW(Table1[Oil changes per year])-(ROW(B$3)-1)),ROWS(A$1:A1))),"") Ctrl Shift Enter
K4 =IFERROR(INDEX(Table1[[Customer Name ]],MATCH(J4,Table1[Vin'# ],0)),"")

Drag the formulas down as far as needed.