View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default Index, Match or what???

I have information on a data page like the following

A B C
8-15 10-16 99
8-16 11-24 98.7

where columns A and B are start and end dates and C is a value for those
dates... how can I stick this data into another sheet formated as a matrix
8-15 8-16
10-16 99
11-24 98.7

I have tried various combinations of INDEX and MAtCH or Vlookup... any help
is greatly appreciated.