I am trying to create a rating scale and in it I have a list of criteria. There are 5 items to choose from and I have a drop-down list to select an "X" for criteria that are met. I want the items to be able to be selected and then a score be designated to a nearby box. ALSO, I want the score to only count for one of those items... for instance...

Cell B64 is Successful TA. Cell C64 would be marked with the X from the drop down. Cell E64 would then convert from a blank to a 3.

Then say I go down to B65 (Demonstrated Leadership). Cell B65 would be marked with an X from drop down. Cell E65 would remain blank if E64 had 3 in it.

This would go on for E64 to E68 so that if any of them are given points, the others turn blank automatically.

Not sure if this is possible, but I know a LOT can be done on Excel. Thanks ahead of time!