Data Validation Question

sdrubezki

New Member
Joined
Aug 5, 2010
Messages
16
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
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

sdrubezki

New Member
Joined
Aug 5, 2010
Messages
16
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

Active Member
Joined
Jul 28, 2009
Messages
400
The link Hiker sent you is a good place to start ---- If you still have trouble reply
 

sdrubezki

New Member
Joined
Aug 5, 2010
Messages
16

ADVERTISEMENT

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

grizz

Active Member
Joined
Jul 28, 2009
Messages
400
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

New Member
Joined
Aug 5, 2010
Messages
16

ADVERTISEMENT

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

Watch MrExcel Video

Forum statistics

Threads
1,122,491
Messages
5,596,462
Members
414,069
Latest member
StudExcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top