#1
|
|||
|
|||
Index using multiple conditional tests
Greetings,
I have to pull a description from a table using multiple conditions to identify the correct entry. The table with the descriptions has a store start and stop date and time. The table requiring the description has a transaction start and stop date and time. I want to test the transaction store number to equal the store number, transaction start date and time to be greater than or equal to the store start date and time, and the transaction end date and time to be less than or equal to the store end date and time. Attached is a file with some sample data. Any assistance would be greatly appreciated. |
#2
|
||||
|
||||
Does this help?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Pecoflyer,
It does help a great deal. I can work on getting the two value errors resolved. Thank you very much |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting Multiple Or Values | Phil H | Excel | 4 | 05-21-2015 04:16 AM |
UDF multiple IFs INDEX-MATCH | grexcelman | Excel Programming | 0 | 02-22-2015 04:20 PM |
Help with multiple match and index formula | ryanwood | Excel | 1 | 09-12-2012 07:53 AM |
Vlookup or Index/Match - Multiple Criteria | ruci1225 | Excel | 1 | 01-15-2012 07:31 AM |
Word 2010 / Master Index / Multiple Documents | bawrites | Word | 0 | 08-09-2011 11:02 AM |