Hi,

I have a roster eg

date 1/1 2/1 3/1

john night day off
andrew day off night
fred off night day


in a cell I would like returned the name of the person who had done a
particular night. eg. who did night shift on 2/1 ie. fred.

I know its a index match, but getting it all wrong or is there another
solution.

andrewm


--
andrewm
------------------------------------------------------------------------
andrewm's Profile: http://www.excelforum.com/member.php...o&userid=23130
View this thread: http://www.excelforum.com/showthread...hreadid=388302