Okay All, I was able to get to work using the following:

=IF($H$8="Day",OFFSET(Data!$E$5,ROW($A$1)+101,MATC H($G$8,Data!$F$3:$CT$3,0)),IF($H$8="Swing",OFFSET( Data!$E$5,ROW($A$1)+102,MATCH($G$8,Data!$F$3:$CT$3 ,0)),IF($H$8="Grave",OFFSET(Data!$E$5,ROW($A$1)+10 3,MATCH($G$8,Data!$F$3:$CT$3,0)))))

Thanks for your help.

EP


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=539484