"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