| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Double Vertical Index & Match
Sheet1
A B C 1 Date Time Score 2 3/1/08 0000 91 3 3/1/08 0600 96 4 3/2/08 0000 95 5 3/2/08 0600 97 Sheet2 A14 = 0000 B12 = 3/2/08 Times and scores can be duplicated and date and scores can be duplicated to i need to validate by date and time which were created seperately by another system. i'd like to do this without creating an extra or hidden columns. I would like a formula to return the scrore 95 from sheet 1 that corresponds to |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
| dynamic, double vlookup, match, index, dget?? different workbooks | Excel Worksheet Functions | |||
Threaded Mode
