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