Looking for a function that will give me the value in the month column for any rows where the value is "10". For instance:

John Jim Kelly
Sept 0 10 10
Oct 10 0 10
Nov 10 10 0


I need a function that will locate the first instance of "10" for Jim and return "Sept" and one the will look for the second instance of "10" and return "Nov".

So, In one cell, I need "Sept", i.e. the first intersection. In another cell (right after it, i.e. column + 1) a function that displays "Nov", the second intersection. And so on down the line (my actual data can contain up to 8 of these intersections).

My original question was here but as I worked on this, I realized I'd asked the wrong thing.

Any one have any ideas?