Help with list of values

A

Abbigail

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List all tables, including document structure 0
Calculate the median value before a specified list 0
Drop down lists in seperate columns 5
Help with multi-level list 0
Adding a big matrix in Word 2013 5
Word VBA - Automatic change content of a cell in table using dropdown list 5
Drop down list control value in vba 2
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0

Top