When working with the data table below, you need column G to populate with the first number in that row beginning from the left.

  A B C D E F G H I
1 Domain Jan Feb Mar Apr May Start End Change
2 www.mydomain1.com   1 4 3 1 1 1 0
3 www.mydomain2.com 2 4 12 18 23 2 23 21
4 www.mydomain3.com     14 12   14 xxx NOT FOUND

Try this array formula: =INDEX(B2:F2,MATCH(1,IF(B2:F2<>0,IF(B2:F2<>””,1)),0))

Remember to press Control + Shift + Enter to enter the formula.