I have data that sort of looks like this:

2010 2011 Launch Product
0 4 Launch A
2 12 B
3 4 C
1 2 D
0 7 Launch E
4 6 F

Data starts in cell A1. What I'd like to do is set up a vlookup formula elsewhere in the Excel sheet that will return the product names from column D for those that have a "Launch" indicator from column C. My trouble is, as you can see, there are 6 rows of actual data and only 2 (rows 2 & 6) have a launch indicator. I want the vlookup to return ONLY when it sees "Launch" in column C, and in a continuous range, like this:

A
E

- as opposed to empty rows in between A & E. Is there a way to do this automatically in Excel?