If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
3 Time frame
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. -- 11050204 ------------------------------------------------------------------------ 11050204's Profile: http://www.excelforum.com/member.php...o&userid=24653 View this thread: http://www.excelforum.com/showthread...hreadid=382364 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Does anyone know how I can display a spacific time frame? 9am-5pm | kris | Running & Setting Up Queries | 1 | May 25th, 2005 08:20 PM |
PREVIOUS MONTH TIME FRAME IN QUERY? | Ned Beck | Running & Setting Up Queries | 2 | June 12th, 2004 12:18 AM |
determine time frame between to table entries | patricia | Running & Setting Up Queries | 2 | June 9th, 2004 01:00 PM |
Outlook 2003 Terminal Server Time Zone issue | Robert Strom | Calendar | 2 | May 26th, 2004 10:50 PM |
time zone & apt times auto changing | Mary | Calendar | 6 | May 25th, 2004 05:44 AM |