Multiple Colums Data Validation

[11curiosity11]

Hi,

I plan to make a sheet for data capturing. Sheet 2 will be my base sheet with all the data in it, and sheet 1 will have blank fields to be filled in via drop downs.

Suppose the heading in Sheet1 are Products(Column A), Brands(Column B), Shades(Column C).

Now assume I select a product in A1[from the drop down], the selection is B1 will be depending upon my selection in A1. Now my question here is how can I create a Data Validation for C1 depending only upon my selection on A1.

eg. from the drop down I select in A1 to be Shoes, in B2 because of the drop down validations I get the brands Nike, Reebok, Adidas. I select any one of them. In C3 I want Shade to come as drop down but based on my selection in A1 and not influenced by any-other thing.

Please Help!

 

[texasaswang]

Using the offset is part of naming a range. Which is what you are basically doing. It also allows for a variable range. You can add / subtract items from your lists in the future.

 

[11curiosity11]

Ohk, Will try it out then. Thanks texasaswang!