Vlookup with CountIF

[c0087]

I need to lookup the value 1 in A1 in the range C1:F1 and return the number of cells it took to match that value in B1...in this case 4
B2 should = 2 A2 looked up in C2:F2
B3 should = 1 A3 looked up in C3:F3

etc

1		0	4	4	1
2		7	2	3	5
3		3	0	0	7

 

[Tetra201]

Try using

=MATCH(A1,C1:F1,0)