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 |
getting a column name
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 | |
All times are GMT +1. The time now is 09:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com