Dependent Dropdown Data Validation

I have data setup (shown in image)
excel test.png

The main idea here is to pick two answers from a drop down and depending on what is chosen a value or values will show in another dropdown. The issue here is this formula does not fit into the data validation list space provided. I can't point the validaion list to a cell because a simple cell cant handle multple answers. In this case only peach and grape will show in the cell because it has only 1 item associated with it.

Please Login or Register  to view this content.

Is there a way to shorten this formula or another way to achieve the desired result?

This question is different the other one i posted. This 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. The other question i posted checks 1 data list as all columns as a whole represent a specific answer and returns that one specific answer not a drop down.