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