How to move values ​​when selecting from a list?

Question

excel

Tell me how to make it so that when choosing from the List (1) Car or Bike, numbers appear under it that have already been prepared on another sheet. A kind of broadcast. And so that you can continue to work mathematically

Answer 1

Example for the file from the screenshot:
in cell C3 we write the formula =INDEX($N$4:$O$14;MATCH($B3;$M$4:$M$14;0);MATCH($C$2;$N$3:$O $3;0))
Stretch