What I'm trying to do is look up the min of say column G, and based on which
cell the min is found in (say G7), give me the contents of the cell beside it
(F7).

I've tried several functions and can't seem to find the correct mix that
will give me what I want. Can anyone help?