I know I just asked a somewhat similar question about SUMPRODUCT IFS, but I still can't figure this one out...

I need to find the MAXIFS of column F where column C = either "Apples", or "Bananas".

=MAXIFS(F$8:F$75,$C$8:$C$75, "Apples" or "Bananas")


Oh, and then I need to return the address of that cell.