Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I select the correct record?
Following is an example of my data, dates as YYYYMMDD:
Row 1: CustomerCode / Number / Effective Date / Expiration Date Row 2: AAAAAAA-4 / SL00001 / 20040301 / 20050301 Row 3: AAAAAAA-3 / SL00001 / 20030301 / 20040301 Row 4: AAAAAAA-2 / SL00001 / 20020301 / 20030301 Row 5: AAAAAAA-1 / SL00001 / 20010301 / 20020301 I have an event date, for example 20030613. I need to find the correct Customer Code so I can select other data stored on the same row. I'm lost as how I can do a lookup the customer code where effective date =< event date < expiration date. I have wondered about some INDEX function or a SUMPRODUCT, but I have not advanced any. Thank you for any insight. -- HansM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
How do I record a macro which should work on multiple files ? | Excel Discussion (Misc queries) | |||
How do I save a record from an excel template to a database in a . | Excel Discussion (Misc queries) |