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

Hi SlicK

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SlicK" wrote in message ...
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" wrote in message
...
Hi SlicK

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SlicK" wrote in message
...
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






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

Do you mean the 10th column?

=VLOOKUP(A1,A5:K177,10)


--

HTH

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


"SlicK" wrote in message
...
"Ron de Bruin" wrote in message
...
Hi SlicK

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SlicK" wrote in message
...
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






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" wrote in message
...
Do you mean the 10th column?

=VLOOKUP(A1,A5:K177,10)


--

HTH

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


"SlicK" wrote in message
...
"Ron de Bruin" wrote in message
...
Hi SlicK

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SlicK" wrote in message
...
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






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





Hi Bob

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

cheers

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" wrote in message
...

"Bob Phillips" wrote in message
...
Do you mean the 10th column?

=VLOOKUP(A1,A5:K177,10)


--

HTH

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


"SlicK" wrote in message
...
"Ron de Bruin" wrote in message
...
Hi SlicK

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SlicK" wrote in message
...
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






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





Hi Bob

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

cheers

"Bob Phillips" wrote in message
...
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" wrote in message
...

"Bob Phillips" wrote in message
...
Do you mean the 10th column?

=VLOOKUP(A1,A5:K177,10)


--

HTH

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


"SlicK" wrote in message
...
"Ron de Bruin" wrote in message
...
Hi SlicK

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SlicK" wrote in message
...
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






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





Hi Bob

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

cheers




Bob

U da man!!
Works a treat.

cheers

"SlicK" wrote in message
...

Bob

U da man!!
Works a treat.

cheers


Glad we cracked it mate!

Regards

Bob