Index Match: First "1" after x

[Median]

I'm convinced there's a super easy solution to the following

Basically, I'm trying to find the column location of the first "1" after the value stated in KP. (KR contains the correct results)

i.e. The first "1" after 287. (193)

The issue is that KP is variable, hence a conventional array doesn't work.

Also, the formula is to be replicated thousands of times - & solutions such as this:

Please Login or Register  to view this content.

.. crashes Excel!

[Kaper]

Not sure if it will be more effective/less computing time hungry (at least it's much shorter :-)) than IFERROR and AGGREGATE, but you may try array formula:

Please Login or Register  to view this content.

[Kaper]

PS. In your profile you mentioned Excel 2016. If that is true you could use built in function:

Please Login or Register  to view this content.

Standard (not array) formula and only one, so shall be much quicker than both above solutions.