Hello,
In Excel 2007, I am using two tables where the array in table 1 has three fields (value (say 6), date and time). Value data is listed in table 2. The fields include information for the value for each day of the year with start and end times, so there are at least 365 entries for value 6 (column B - date, column C - start time, column D - end time). The information I need to look up is in column E of that table 2. I need a command that can match 3 criteria in table 1 with value, date, and time that is between columns C and D and populate that information in Table 1. MATCH does not work well since I don't have exact match for time. VLOOKUP may work if it can handle AND statements. Can someone help me with that?
Thank you in advance.
In Excel 2007, I am using two tables where the array in table 1 has three fields (value (say 6), date and time). Value data is listed in table 2. The fields include information for the value for each day of the year with start and end times, so there are at least 365 entries for value 6 (column B - date, column C - start time, column D - end time). The information I need to look up is in column E of that table 2. I need a command that can match 3 criteria in table 1 with value, date, and time that is between columns C and D and populate that information in Table 1. MATCH does not work well since I don't have exact match for time. VLOOKUP may work if it can handle AND statements. Can someone help me with that?
Thank you in advance.
