Hi,

I was wondering if anyone could help me with this problem. I am a
track coach and I created a matrix to list athletes and events. I was
wondering if you could write a formula to scan a row of events and find
an event then display the athlete in a new column list by event.

Like this

Name Event 1 Event 2 Event 3 Event 4
Bob 100 200 1600 3200
Jim 400 100 1600 200
Larry 110 200 400 3200


Show a List as follows

100 200 400 1600 3200
Bob Bob Jim Bob Bob
Jim Jim Larry Jim Larry
Larry

Thank you for the help.

I have tried vlookup, hlookup, match and index with little success.


--
grizzly1733
------------------------------------------------------------------------
grizzly1733's Profile: http://www.excelforum.com/member.php...o&userid=33069
View this thread: http://www.excelforum.com/showthread...hreadid=528822