Excel HELP PLEASE!!!?

Question

Im creating a spreadsheet for my ICT coursework, its bases on a Car dealer, so iv have created drop down lists of car Models and Makes. But i want the makes to come up specific to the car model. For example if someone selects Ford in the Make drop down list then in the Model i only want the Ford models to come up, right now i have every single model of different makes coming up, how can i just get the specific models for the car makes, so on Mercedes only mercedes models come up and on Lexus on Lexus models come up?
Thanks alot!!

Answer 1

Not sure how you have your spreedsheet setup but this is what I did and it seemed to work: If not email me

A1 = "Manufacturer"
B1 = "Model"

Then list your data: A2 = "Ford" B2 = "Mustang"
A3 = "Acura" B3 = "RSK
A4 = "Ford" B4 = "F150"
etc

Go to A1 and click Data - Filter - Auto Filter. When you select Ford all the Ford cars should show up.

Answer 2

If you have Excel then you probably have Access. This is a database application which allows you to run more in depth queries on multiple tables.

I am sure that you will find lots of tutorials on Access, and one of them will show you something very similar to what your coursework is based, in which case you could modify it where needed.

Answer 3

Try this:
In Column F, from F7 to F14, enter:
Fiat Fiat Ford Ford Ford Ford Honda Honda
In Column G, from G7 to G14 enter:
Bravo Uno Escort Fiesta Ka Granada Civic CR-V
In Column H, from H7 to H9 enter:
Fiat Ford Honda
In cell J7 enter:
=MATCH(i17,$F$6:$F$14,0)
In cell J8 enter:
=IF(OFFSET($F$5,J7+1,0)=
$i$17,J7+1,0)
drag this down through J9, J10,J11, J12, J13, J14
so that J14 will contain:
=IF(OFFSET($F$5,J13+1,0)=
$I$17,J13+1,0)
In cell K8 enter:
=IF(J7>0,OFFSET($F$5,J7,1),"")
drag this down through K9 to K14

Put your dropdown selection for "Make" in cell i17, selecting from H7:H9
Your dropdown selection for "Model" (put it in i19 for now) should select from K7:K14

And for the cherry on top:
In cell J19 enter:
=MATCH(I19,K7:K14,0)

now conditionally format cell i19:
Format
Conditional Formatting
Formula Is
=ISNA($J$19)
.... format the font colour to match the background

and as an extra:
=J7+i19-2 gives the position of the car in the list

Keep the table of cars sorted: Make, Model
you'll have to maintain a "Make" table (column H) in addition to the "Car" table columns F & G.

Once built, move things around as you please, but keep F5 in relation to the "Car" table.

Answer 4

mikea_va answers is the right one. Btw Excel is a database of sorts.

Answer 5

If I had the sheet in front of me I can probably figure it out but I'm too much of a hands on person. Good luck. Sounds cool

Answer 6

i dont think you can do this on Excel however it would possibly work with Database