Hi Abbigail,

You can use an IF function containing AND and OR operators to do what
you need.

If you have 5 choices in column 1, 5 choices in column 2. then there
are 25 possible combinations. And you mentioned this needs to result in
the result of a possible 4 values.

You need to work out what your rule is to map each of these 25
combinations to a result and then figure out what your function needs
to be

Eg

Column 1 Column 2 Column 3
Cake Morning Bad*
Kebab Evening Bad*

The function in column 3 * might be
IF(OR(AND(A2="Cake",B2="Morning"),AND(A2="Kebab",B 2="Evening")),"Bad","Good")

Of coure since you have 25 coimbinations tis formula may be quite
lengthy

just draw out your combinations and try and work out your rule.

Ant