Issue in Data Validation

I am using Data validation for some activities Eg..I have some activity called 1,2,3 in Activity column (F column) if i select the activity 1 in F Column then in G column it shoul come only 1 instead of 1,2,3 and similarly if I select 2 it should come 2 only instead coming all 1,2,3 in G column how to do this?

Attached the same sample sheet for your reference

Hi Anwitha,

Your drop-downs show the same options because they have the same data validation setup. What you're after, I think, it called Dependent Data Validation, and there is a good example of how to set it up here:

http://www.contextures.com/xldataval02.html

Hope that helps!

Post the workbook you created after implementing the steps outlined in the link Paul posted. Otherwise, nobody will know what you did or how to help you.

You're on the right track.

You've defined range names for "Campus" and "Others". You have not yet defined range names for "Off Campus" and "Walk In".

The dependent data validation works best if there are no spaces in the dependent list columns, since range names do not allow spaces. Try to come up with names without spaces or use an underscore _ sign instead of the space for both the data valuation list value and for the range name.

Also, the second data validation is pointing at the absolute reference

=INDIRECT($B$2)

Since you want each row to be evaluated individually, you need to make the row reference relative, i.e. without the $ sign.

=INDIRECT($B2)

Start this in C2 and copy down.

edit:

you can also use this workaround: create ranges named Off_campus and walk_in (with underscores) and leave the selection values in the first drop-down as they are.

Then, in the data validation for the second drop-down, starting in B2, use the validation formula

=INDIRECT(SUBSTITUTE(B2," ","_"))

this will substitute the space in the value in column A with an underscore and render the correct range name. See attached.
cheers,