I have a spreadsheet of questions - about 250 in total. The user is supposed
to select their answer from a drop down box. There are eleven possible
answers to the various questions AND the drop down boxes have different
combinations of of the eleven answers. For instance, in some cases we have
only yes or no drop down answers and others have an answer of monthly,
quarterly, NA, etc.

What I am looking to do is create a formula in a separate cell that looks to
the answer selected from the drop down box and reduce it to a letter, with
each answer having a separate letter.

Given the number of questions I would like to have the same formula for all
questions; meaning nesting eleven IF/Then 's in a formula.

Any suggestions? Thank you for your problem solving efforts in advance.
K