Not Sure

[Nobody]

Hi,



Can anyone help?



If I use a Form selecting from the range "make" I want the next Form to be
able to pick from the "model" range of that make.



So if I picked Ford in the 1st form, the 2nd form will only give me the
options of Mondeo LxTD or Mondeo Aspen. The other information I can already
obtain using Vlookup() but I cannot find a way of inputting the "model"
range into the Vlookup()



In cell A1 the form will bring in the option picked (ford Or Vauxhall)

What I need is in cell B2 I want to be able to pick from only the cars made
by ford or vauxhall which ever option was picked, so if it was Ford, it
would pick from "ford" range.



A1 = Ford

B2 =VLOOKUP(A1,(A1),2,FALSE)





Make Model Value Group

Ford
Mondeo LXTD
£12000
8


Mondeo Aspen
£13000
9

Vauxhall
Cavalier
£4000
6


Vectra
£8000
8


TIA.



Mike.

 

[Debra Dalgleish]

You could use dependent data validation lists. There are instructions here:

http://www.contextures.com/xlDataVal02.html

 

[Nobody]

That is exactly what I needed to know.
Cheers for that !!! Spot on.

Mike

 

[Nobody]

That is exactly what I needed to know.
Cheers for that !!! Spot on.

Mike