| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup depending upon 2 criteria
I am having a little difficulty with the Index / match functions.
I have a spreadsheet set out as follows Date / Time CC Phase 14/11/2008 20:00:00 INTERRUPT 14/11/2008 20:00:00 B13 RELEASE 14/11/2008 21:00:00 SETUP 14/11/2008 21:10:00 B1B RELEASE I would like to return the CC for for only when Phase=Release and Date / Time = 14/11/2008: 20:00:00 Any Advice would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a chart depending on different criteria | Charts and Charting in Excel | |||
| How to use INDEX in an ARRAY that changes depending on a criteria | Excel Worksheet Functions | |||
| Populate, Depending on Criteria | Excel Discussion (Misc queries) | |||
| Auto copy down depending on criteria | Excel Worksheet Functions | |||
| Delete row depending on criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
