Returning Cell Contents of One Cell Based On Another Cell
 

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?

Returning Cell Contents of One Cell Based On Another Cell
 

=OFFSET(MIN(G1:G1000),1)

Dave
--
Brevity is the soul of wit.


"DallasLDY" wrote:

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?

Returning Cell Contents of One Cell Based On Another Cell
 

Sorry I mis-read your question, please ignore my response!
--
Brevity is the soul of wit.


"Dave F" wrote:

=OFFSET(MIN(G1:G1000),1)

Dave
--
Brevity is the soul of wit.


"DallasLDY" wrote:

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?

Returning Cell Contents of One Cell Based On Another Cell
 

This will find the FIRST instance of the min value in G1:G21

=INDEX($F$1:$F$21,MATCH(MIN($G$1:$G$21),$G$1:$G$21 ,0))

"DallasLDY" wrote:

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?

Returning Cell Contents of One Cell Based On Another Cell
 

I guess what I'm really looking for is a function that will give me the cell
reference where the minimum value is located. I don't want the min value,
but the cell in which the min value is located.

Then I can plug that into the offset function (or a variety of other
functions) and get the value I need.


"Dave F" wrote:

Sorry I mis-read your question, please ignore my response!
--
Brevity is the soul of wit.


"Dave F" wrote:

=OFFSET(MIN(G1:G1000),1)

Dave
--
Brevity is the soul of wit.


"DallasLDY" wrote:

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?

Returning Cell Contents of One Cell Based On Another Cell
 

Thank you, you put me on the right track! This finally worked:

=INDIRECT("f" & (MATCH(MIN($J$2:$J$20),$J$2:$J$20,0))+1)

I added the '1' at the end because I had 1 row of headers.

I thought I tried something like this before and it didn't work, but it
finally is working perfectly.

Thank you again.

Leslie


"Duke Carey" wrote:

This will find the FIRST instance of the min value in G1:G21

=INDEX($F$1:$F$21,MATCH(MIN($G$1:$G$21),$G$1:$G$21 ,0))

"DallasLDY" wrote:

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?