Multiple Drop Down Data Check

I have the following structure.
excel3.png

So i have a huge data list and depending on the anwsers provided from the three question one specific anwser would be allowed.

For example orange->morning-yes would yield fresh1

but orange->morning-no- would yield rotten 4.

The logic would check the since there is duplicates of fruit, morning determines which specific instance of fruit, then the 'good' column would can yield the specific status because we have narrowed the selection down within the first two question.

good-yes would always be fresh
good - no would always be rotten

I got confused and the formula got messy when i tried to write it, is there a way to accomplish the above task?

You've posted this question here twice, and also on other online forums. Please read this message for cross-posters