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.
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?
not a professional, just trying to assist.....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks