My AI formula is not working - nested IF statements

[Dgmknzgrl]

I'm attempting to assign an Award Name to an Award Picked field if an applicant says 'Yes" they want to apply for that award.

So, if someone says 'yes' to the First Award, I would like the Award Picked column to read "First Award Name".  Same for Second, Third, etc. (I have 21 awards). 

If they don't say yes, then it should be 'blank'.

I tried the AI formula (which came up with the same thing I tried myself) but the Award Name does not appear, only 'blank'.

Any help would be much appreciated!!

[BillH · Accepted solution]

Change the 'yes' to 'Yes' in the formula (to match the select) and I believe it will work.

[Dgmknzgrl]

Bah!!! So simple!  Thanks BillH!!!  (Score 1 for humans against the machine!)