How to pull a title field referencing data from a row

In the attached document there are three rows of data.

The data changes from time to time. What I need to do is pull the Month is which row three starts to go positive.

For example in the attached document that would be Month 17.

I have started to write a formula but they pull the wrong month. I can't seem to figure it out.

=IF(ISERROR(FIND(">0",Sheet1!3:3)),Sheet1!1:1) Pulls month 10

=IF(COUNTIF(Sheet1!3:3,">1"),LOOKUP(1,1/--(Sheet1!3:3),Sheet1!1:1)) Pulls month 24

Thank you in advance.

AttachmentSize
Excelhelp.xls.xlsx9.36 KB

RE: How to pull...

Hello,

First - sorry for my English.

If I understand you correct, the follow formula maybe help you:

= IFERROR(INDEX(A1:X1, MATCH(1, IF(A3:X3 > 0, 1, 0), 0)), "There are no positive value!")

Type it in some cell and press CTRL + SHIFT + ENTER because of to be enter as array formula.

Best regards.