if the time can only be found on one of the three sheets it could be
done by

=if(isna(1st lookup),if(isna(2nd lookup),if(isna(3rd lookup),"Not
found",3rd lookup),2nd lookup),1st lookup)

where each lookup is a lookup function for one of the three sheets.

If the time could be found on more than one sheet what do you want to
do?


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=382364