Get data at iterative intersections at x and y axis

[SandPounder1]

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?

[Kaper]

If your data is in A1:D4 in say B13 insert array formula (Ctrl+Shift+Enter comitted):

Please Login or Register  to view this content.

copy down and right and the output will be:
Oct Sept Sept
Nov Nov Oct

[SandPounder1]

Works, but I need to tell the function who to look for, either "John", "Jim", or "Kelly" and only return the months for that person.

Also, the location of the cells in which I need to insert the month are several columns apart (in the actual spreasheet, they are 17 columns away from each other). So the value "Jim" is located in Column AM, the first month match for "Jim" to 100 needs to be in column AT "Sept", and the next month match would be in column BJ "Nov" and so on for up to 8 searches.