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


--
mordor
------------------------------------------------------------------------
mordor's Profile: http://www.excelforum.com/member.php...o&userid=23459
View this thread: http://www.excelforum.com/showthread...hreadid=498592

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
|