Combo Box

[SlicK]

Hi

I have a list of data.
Column A is the Subject and then there is say 10 columns with specific data
relevant to that Subject.

I have all the Subjects from Column A in a drop down Combo box on ROW 1.
What I need to do is display in say ROW 2 the data that is on the entire row
that matches what is chosen from the Combo box.

so for example.
The subject is car manufacturer(Ford, Vauxhall, Volkswagon)
The rows would contain each model.
When I chose the manufacturer it would tell me in ROW 2 the Models
availalable.

Hope this makes sense

SlicK

 

[Ron de Bruin]

Hi SlicK

You can use the Vlookup function with as lookup value the combobox value

 

[SlicK]

Hi SlicK

You can use the Vlookup function with as lookup value the combobox value

Hi Ron

When I use
=VLOOKUP(A1,A5:K177,2)
It only displays the data from Column B(i.e the 2 at the end of the formula)
in that specific cell.
Is it possible to display the data from say 10 cells on that row?

cheers

 

[Bob Phillips]

Do you mean the 10th column?

=VLOOKUP(A1,A5:K177,10)


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[SlicK]

Do you mean the 10th column?

=VLOOKUP(A1,A5:K177,10)


--

HTH

RP
(remove nothere from the email address if mailing direct)


ROW

Hi Bob

No i need to show columns 2 to 10 (in equal cells that is)

cheers

 

[Bob Phillips]

Then use

=VLOOKUP(A1,A5:K177,COLUMN(B1))

and copy across the cells


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[SlicK]

Then use

=VLOOKUP(A1,A5:K177,COLUMN(B1))

and copy across the cells


--

HTH

RP
(remove nothere from the email address if mailing direct)

Bob

U da man!!
Works a treat.

cheers

 

[Bob Phillips]

Bob

U da man!!
Works a treat.

cheers

Glad we cracked it mate!

Regards

Bob