Index and match?
 

Hi,

Question: I need to take a number (minimum value) from one cell and find
the cell it came from, then return the text of the correspondeing cell to the
right but return the text that is 3 cells above. The Net Score of -4 would be
the value in say C30. I would want to show in C31 the text in Name1 (A1)

EX.

Name1
Hdcp 22 9
Score 5
Net Score -4

Name2
Hdcp 7 3
Score 2
Net Score -1

Index and match?
 

Is all this data in a single column? If so it will be hard to fulfill your
request
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"bikemrh" wrote in message
...
Hi,

Question: I need to take a number (minimum value) from one cell and find
the cell it came from, then return the text of the correspondeing cell to
the
right but return the text that is 3 cells above. The Net Score of -4 would
be
the value in say C30. I would want to show in C31 the text in Name1 (A1)

EX.

Name1
Hdcp 22 9
Score 5
Net Score -4

Name2
Hdcp 7 3
Score 2
Net Score -1

Index and match?
 

No, this is in three colums. Column 1 has the text, column 2 has a single
digit and Column three has the values.

"Bernard Liengme" wrote:

Is all this data in a single column? If so it will be hard to fulfill your
request
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"bikemrh" wrote in message
...
Hi,

Question: I need to take a number (minimum value) from one cell and find
the cell it came from, then return the text of the correspondeing cell to
the
right but return the text that is 3 cells above. The Net Score of -4 would
be
the value in say C30. I would want to show in C31 the text in Name1 (A1)

EX.

Name1
Hdcp 22 9
Score 5
Net Score -4

Name2
Hdcp 7 3
Score 2
Net Score -1

Index and match?
 

A1:A6 has some names
B1:B6 has some numbers
=INDEX(A1:A5,MATCH(MIN(B1:B5),B1:B5,0))
returns the name from A associated with the minimum number in B
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"bikemrh" wrote in message
...
No, this is in three colums. Column 1 has the text, column 2 has a single
digit and Column three has the values.

"Bernard Liengme" wrote:

Is all this data in a single column? If so it will be hard to fulfill
your
request
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"bikemrh" wrote in message
...
Hi,

Question: I need to take a number (minimum value) from one cell and
find
the cell it came from, then return the text of the correspondeing cell
to
the
right but return the text that is 3 cells above. The Net Score of -4
would
be
the value in say C30. I would want to show in C31 the text in Name1
(A1)

EX.

Name1
Hdcp 22 9
Score 5
Net Score -4

Name2
Hdcp 7 3
Score 2
Net Score -1

I don't mean to "Jump in the middle" here iwth a question of my own, but I'm really having a hard time with this. I need to find a way to find the minimum value of a cell that corelatetes to the other cells around it. For example:
In column A I have text that has to be correlated with the numbers in column B (You see Column A has the names of the Suppliers while Column B has their rates). And I need to mathc them up with what region they came from (Which is text in column C) and in Columns D & E I have the carriers and their rates.
So, in a nutshell, I need a formula that can return the minimum supplier rate from the same terminal it's quoted from with the minimum rate from the carrier. Any and all help will be appreciated.