Hi,



I would appreciate your advice; I have a spreadsheet in Excel, which I'm
trying to make as easy as possible for users (seriously).



I have three columns and in two of the columns I have a drop down list, how
can I get the third column to come up with the answer, however columns one
and two have many different combinations. The answer is also in text and
not in numbers, examples could be:



Negligible + Moderate = Medium

(Column 1, list of values + Column 2, list of values = Column 3 - this value
would just appear).



There are 5 values in each of the list of values in columns 1 and 2, and
there combination can equal a total of any 4 in column 3.



I hope the above makes sense, and any help would be appreciated.



Thanks,