'Is there a way in Excel to deliver first instance of a number in a list of errors logical and number values?

Here is the reverse 2 way lookup formula that delivers column headers by matching first instance of numbers beneath and getting colnum to index function.This formula works fine if there are no duplicate values

Sample data

Pr/Mo jan feb march apr
pro1 2 3 1 4
Pro2 5 6 7 9
Pro3 10 9 11 12

Formula: $A$6 value is 9

=Index($B$1:$E$1),,Sum(if($B$2:$E$4=$A$6,(Column($B$1:$E$1)-Column($B$1))+1)

If function returns : {False,False,False,False,False,False,False,3,False,1,False,False}

3 is recquired here which is first instance not 1 but how to using formula not VBA.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source