Array formula
Try this (still array entered):
=INDEX(C$2:C$8800,MATCH(1,($A$2:$A$8800=$Y2)*($S$2 :$S$8800=$AA2),0))+TIME(1,0,0)
--
Biff
Microsoft Excel MVP
"Sandy" wrote in message
...
Hello Folks,
I am using the following array formula:
{INDEX(C$2:C$8800,MATCH(1,IF($A$2:$A$88800=$Y2,IF( $S$2:$S$8800=$AA2,1)),0))}
The formula returns a Date/Time and I would like to add 1 hour to the
return.
Thanks
|