View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AirgasRob AirgasRob is offline
external usenet poster
 
Posts: 21
Default Index and Match I Presume...Maybe

A B C D E
1 01/01/09 02/01/09 03/01/09
2 TEST1 TODAY1 1 2 3
3 TEST2 TODAY2 4 5 6
4 TEST1 TODAY2 7 8 9

Criteria:
A5 = "TEST1"
A6 = "TEST2"
A7 = "02/01/09"

If row = A5(Column A) and A6(Column B), intersect on column = A7 (Row 1).
Need the answer to return as "8".