Try this in C3 ...
=INDEX($A$1:$A$2,MATCH(20,C$1:C$2,0))
You can also copy this along row 3 for other columns.
Rgds,
ScottO

"mordor" wrote
in message
...
|
| please help me with this one ok?
| lets say i have two columns. in the first raw i have the names:
| a1= daniel
| a2=bill
| the next two rows are numbers
| b1=10
| b2=20
| c1=20
| c2=40
| what i need to do is to know who got the 20 in the previous row.
| so the cell c3 will be "bill" because in the "b" row bill got "20"
as
| in the "c1" cell.
| it looks like that
| ----3-----2-----1----
| ----------Bill---Daniel--a
| ----------20----10-----b
| ---bill----40-----20----c
|
| please help asap
|
|
| --
| mordor
| -------------------------------------------------------------------
-----
| mordor's Profile:
http://www.excelforum.com/member.php...o&userid=23459
| View this thread:
http://www.excelforum.com/showthread...hreadid=498592
|