ok here is my formula:

=INDEX('Performance Summary'!D4:H4,MATCH(MIN('Performance
Summary'!D24:H24),'Performance Summary'!D24:H24,0))

Basically the data in cells D4:H4 are years like 2008, 2007 etc.

They are the values I need returned.

However - in my formula with the MIN section - I only want to include those
that are greater then 0.

So I need to have cells D24:H24 in there but if say H24 is zero then I don't
want it to include that.