Lookup one cell and return multiple cells

[Tordah]

I would like to see that orange is in cell A2 and in return have it display what is in cells C2-C5, but as well need to concurrently lookup Apple and Pear to do the same thing in the same function. But as Pear is one short for a return I need the extra cells to show blank if there is nothing.

I have attached a sample form for this.

[JohnTopley]

Where is the data to be displayed? is it as drop-down list?

[Tordah]

No it's the items under each return, those return lists will be in another sheet, like a data dump area