Recognizing Populated Cell, Using It To Populate Another

Hi,

I have a spreadsheet that documents staff training. Certain combinations of training qualify them for different levels of responsibility. I would like to set up my table so that it populates the levels of responsibility based on what is entered in the course columns.

For example, lets say there are 20 different courses (columns A through T). Columns U through Z are the levels of responsibility (U could be squad boss, V could be commander, X could be division supervisor). Now let's say if you have course A, B, C you are a squad boss (or "Yes" under "U"). If you have A, B and F you are "Commander" or "Yes" under "V".

Right now under columns A through T it is populated with things like "x08" or "x11" symbolizing "2008" or "2011". Basically I'm wondering if a formula can tell it to populate columns U through Z with a "Yes" pending the combinations in A through T? I assume it's some sort of "if/then" statment.

Thoughts?

Something like:
=IF(AND(A2<>"",B2<>"",F2<>""),"Yes","") for Col V (Commander)

Originally Posted by Cutter

Something like:
=IF(AND(A2<>"",B2<>"",F2<>""),"Yes","") for Col V (Commander)

Thanks! That looks like like it worked!

That formula worked, so here's a twist: can I have a separate worksheet with the positions listed on it and formulae referencing the first worksheet?

Yes, you can.