Thread: Combo Box
View Single Post
  #7   Report Post  
SlicK
 
Posts: n/a
Default


"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