Hi All,

First of all - My apologies, i was trying to add an excel doc but it wouldn't work so i posted it below.

I am trying to query a table by having an input cell which then returns all relevant lines from the table containing that input information. I am using a pivot table at the moment but it wont let me return a text cell - i think this is because pivot tables are numerical?


Page 1

Random Fruit Class Comment
X Apple A Okay
X Apple B Rotten
X Banana A Okay
X Banana B Rotten
X Banana C Maybe
X Orange A Okay
X Watermelon A Okay


Page 2 - Example

Fruit
*Input* Banana *Input*

Fruit Class Comment
*Output*
Banana A Okay
Banana B Rotten
Banana C Maybe
*Output*


Let me know your thoughts,

Thanks,

Ad