Multiple Drop Down Data Check

[jumpman8947]

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?

[azumi]

I have trouble to upload my example, please follow this link

https://simpan.ugm.ac.id/s/GQyfuBmhe5N14jp

and maybe this link helpful for DV tutorial:
http://www.contextures.com/xlDataVal01.html

[jumpman8947]

The last Column should automatically display fresh or rotten depending on user selection of the previous 3 categories.

I will edit my post to be more clear.

[teylyn]

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

[jumpman8947]

This question is different the other one i posted. The other post its checking different data lists depending on output of one specific cell and then checking for a match and generating a drop down with multiple answers. This post checks 1 data list as all columns as a whole represent a specific answer and returns that one specific answer not a drop down.