software

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 quot;billquot; because in the quot;bquot; row bill got quot;20quot; as
in the quot;c1quot; 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: www.excelforum.com/member.php...oamp;userid=23459
View this thread: www.excelforum.com/showthread...hreadid=498592Try 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

quot;mordorquot; gt; 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 quot;billquot; because in the quot;bquot; row bill got quot;20quot;
as
| in the quot;c1quot; 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:
www.excelforum.com/member.php...oamp;userid=23459
| View this thread:
www.excelforum.com/showthread...hreadid=498592
|