View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
storm warden storm warden is offline
external usenet poster
 
Posts: 2
Default 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.