I need to return a value from another column based on another value I'm using
to filter the results. I can use index and match to do this.

=INDEX(D10:D100,MATCH("New",L10:L100,0))

This returns the value from column D that corresponds with the first
available instance of the word "New" in column L. I would also like to
return the 2nd value and 3rd value associated with the instance of the same
word. I've tried to insert LARGE in a couple of places but I can't seem to
get it to work (no giggling please this is serious business). Any help would
be appreciated.