getting a column name

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

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" <[email protected]> wrote
in message
news:[email protected]...
|
| 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
|