Data Validation Question

[sdrubezki]

Hi everyone,

I'm trying to build dependent lists in Sheet1, with the source in Sheet2 as follows:
Brand Product
1 pen
1 pencil
1 computer paper
2 laptop
2 telephone
etc

The idea is that user chooses brand and only products of that brand are shown. But I want to show the brand only once.

I tried pivot tables and offset without success (perhaps I don't use correctly). Can anyone assist?

Thanks in advanced.
Sebastian

 

[hiker95]

sdrubezki,

Try:

Dependent validation lists. Debra has a neat little tutorial here.
http://www.contextures.com/xlDataVal02.html

 

[sdrubezki]

Hi, thanks for replying. One detail I forgot to mention is that in the adjacent columns to the product I have more data: column1: brand, column2: product, column3: brand address, etc (total 7 columns), so it's not just the product list. Any idea?

 

[grizz]

The link Hiker sent you is a good place to start ---- If you still have trouble reply

 

[sdrubezki]

I'm sorry, but I just can't make it work. I tried indirect with vlookup but it doesn't work. Please!!!

 

[grizz]

try this in sheet 2 ---- A1 - Canada
A2 - usa
A3- Asia
in name box type in country
sheet 1 A1 - data validation / list / source =country

sheet 2 ------- B1 - Ontario
B2 - Quebec
B3 - Alberta
in name box type in Canada
sheet 1 B1 - data validation / list / source =indirect(A1)

sheet 2 ----- C1- Toronto
C2 - Ottawa
C3 - Kingston
in name box type in canadaontario

sheet 1 in C1 - data validation / list / source
=indirect(substitute(A1&B1," ",""))
sheet 2 in D1 - Florida
D2 - Texas
D3 - Maine
in name box type in USA

 

[sdrubezki]

hi grizz, thanks for replying. Any chance I can send you an example?

 

[grizz]

sure send away

 

[sdrubezki]

how do i do it here? or mail?

 

[grizz]

click on my name and send private message