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 100$
Apricot 120$
Banana 90$
*
*
*
And So On.

I want to display "Apple" in Cell C45 after I apply the filter to Column A
for Apple.

Regards
Sonu