Data Validation and Indirect formula

[sshrikanth2]

Hi,


I have the two columns wherein column "A" is meant for updating the activity, column "B" for sub-activity and each activity has several sub-activity which are mentioned as below so when i select the any of the activities listed below the sub-activity should appear corresponding to that activity using data validation. Can you please provide solution for this.

Activity​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​	Sub-activity​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​
Review​ ​ ​ ​ ​	Reviews​ ​ ​ ​ ​ ​ ​ ​ ​ ​ ​
Training​ ​ ​ ​ ​	PTR​ ​ ​ ​ ​
Break​ ​ ​ ​ ​	Buzz​ ​ ​ ​ ​
No_Work​ ​ ​ ​ ​	Process Meeting​ ​ ​ ​ ​
Production​ ​ ​ ​ ​	Others​ ​ ​ ​ ​
Quality Check​ ​ ​ ​ ​
Reports​ ​ ​ ​ ​	Training​ ​ ​ ​ ​ ​ ​ ​ ​ ​
Management​ ​ ​ ​ ​	Process Training​ ​ ​ ​ ​
Query Management​ ​ ​ ​ ​	Others​ ​ ​ ​ ​
	Break​ ​ ​ ​ ​ ​ ​ ​ ​ ​
	Tea​ ​ ​ ​ ​
	Lunch​ ​ ​ ​ ​
	Dinner​ ​ ​ ​ ​
	Others​ ​ ​ ​ ​
	No Work​ ​ ​ ​ ​ ​ ​ ​ ​ ​
	System Issue​ ​ ​ ​ ​
	No Inventory​ ​ ​ ​ ​

<TBODY> </TBODY>

 

[T. Valko]

Hi,


I have the two columns wherein column "A" is meant for updating the activity, column "B" for sub-activity and each activity has several sub-activity which are mentioned as below so when i select the any of the activities listed below the sub-activity should appear corresponding to that activity using data validation. Can you please provide solution for this.

Activity​	Sub-activity​
Review​	Reviews​
Training​	PTR​
Break​	Buzz​
No_Work​	Process Meeting​
Production​	Others​
Quality Check​
Reports​	Training​
Management​	Process Training​
Query Management​	Others​
	Break​
	Tea​
	Lunch​
	Dinner​
	Others​
	No Work​
	System Issue​
	No Inventory​

<TBODY>
</TBODY>

See if this helps:

http://contextures.com/xlDataVal02.html