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