Returning row data dependant on two drop down lists

[fimbertil]

Hi,

I am making a data sheet that can be explained likes this:

I have a drop down list of car brands
I have a drop down list of models of each brands

now i want to, when a given model is selected, to print the data of the selected model.

the row that needs printed should be printed in equal amount of cells.

A

B

C

D

E

F

G

H

I

J

K

L

1

Brand

Model

Horsepower

Torque

Motor

Brand

Model

Horsepower

Torque

Motor

2

Drop Down

Drop Down

Returned data

Returned data

Returned data

Ford

Focus

100

250

2.0

3

Volvo

S60

125

300

2.5

4

Fiat

Panda

70

100

1.2

5

Seat

Ibiza

90

250

1.6

In this example there is only 1 model pr brand, but there will be many more.

How to i get the returned data to be dependent on the chosen model in the drop down list?

i am naming the rows like (I2:K2) is called "focus".

the second drop down list is using =indirect(A2)

Hope it make sense and the info needed is there.

Thanks

[dilipandey]

Hi fimbertil,

welcome to the forum.
Please upload a sample excel workbook along with your expected output.. thanks.



Regards,
DILIPandey
<click on below * if this helps>

[fimbertil]

Thanks!

There you go:

Car stats.xlsx

I want to hide the right side of the yellow column, then when selecting in the two drop down lists, the data from the hidden tables(Columns K:M)should be returnded in D:F

hope it helps you help me

[dilipandey]

Okay... since all the model name are different, use below formula:-

Please Login or Register  to view this content.

see attached:-Car stats.xlsx


Regards,
DILIPandey
<click on below * if this helps>

[fimbertil]

OMG!

That is just what i wanted, you have no idea for how long i have searched this on internet.

Thank you very much!!

[dilipandey]

you are welcome fimbertil

cheers

Regards,
DILIPandey
<click on below * if this helps>