getting a column name

  • Thread starter Thread starter mordor
  • Start date Start date
M

mordor

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" a
in the "c1" cell.
it looks like that
----3-----2-----1----
----------Bill---Daniel--a
----------20----10-----b
---bill----40-----20----c

please help asa
 
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

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?action=getinfo&userid=23459
| View this thread:
http://www.excelforum.com/showthread.php?threadid=498592
|
 
Back
Top