3 Time frame

1

11050204

Hi all,
I have 3 different sheets with 3 different time frame (Daily, Hour, 5
Minutes). I would need a formula that would allow me to look for a set
time (5PM) on each time frame sheet and then, when Excel finds a line
where the time is 5PM, it gives me the value of a cell on that line.

Thanks.
 
D

duane

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?
 
Top