Index and match?

B

bikemrh

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
 
B

Bernard Liengme

Is all this data in a single column? If so it will be hard to fulfill your
request
best wishes
 
B

bikemrh

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

Bernard Liengme

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
 
F

frankjh19701

Bernard said:
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
Click to expand...

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.
 
Top