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.
Bookmarks