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.
Attachment | Size |
---|---|
Excelhelp.xls.xlsx | 9.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.