I want to find out a Specific Word in a Column after I have applied a filter
to specific Column.

Column A Column B
Apple 95$
Apricot 120$
Banana 90$
Grapes 80$
*
*
*
And So On.

I want to display "Apple" in Cell C45 after I apply the filter to Column B
for say Fruits less than 100$, as the Column A display Grapes,Apple & Banana
too.
Can you pls help me out just to show the Apple in a Cell say C45, even
though banana & grapes are displaying in the Column A.

Regards
Sonu