Data Validation

[hivedrone2112]

I'll try to make this brief.

Column A has A B C D E F G

Column B has A10, B20, C30 etc

Column C Has A1010 B1010 C1010 etc

Column F has A1014, B1019 etc.

These need to be pickable from a drop down menu. Is it possible to execute a validation that makes sure that if Column F has B1019, that columns A-C are all correctly pointing to the B entry (B, B10, B1010)?

[karan]

Hi,

You can use multiple validation.

You will need to define groups of all the values that contain A, B, and C separately and name them anything like AGROUP, BGROUP, CGROUP, etc.

So, in this case, AGROUP will contain values such as A10, A1010, A1014, etc.

Put the following list validation in cell B1 and copy-paste it to all the required cells from B to F column:

=INDIRECT(CONCATENATE($A1,"GROUP"))

Now if you select A in the first column, you will only have the options that have A in it to put in the cells in columns B to F.

Refer the attached file.

--Karan--

[hivedrone2112]

Thanks Karan this worked perfectly.

[karan]

If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]

--Karan--