View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Slider Slider is offline
external usenet poster
 
Posts: 3
Default Index, Vlookup, Offset

I have the following raw data setup:

Invoice# Date Description Amount
2007-1 4/1/07 Signage 250.00
2007-1 4/1/07 Mugs 115.00
2007-2 4/2/07 Signage 275.00

In a summary sheet:

I would like to pull the first "Date" for "Invoice#" 2007-1 on line 1.
If Invoice# 2007-1 has a second record, I would like to then pull the second
"Date" for "Invoice#" 2007-1 on line 2.

Thank you in advance for your help