I had tried using "IF" but the "1" could be in any cell across the table, and i didnt want to have to create a long formula with 20 "IF" Logical tests!Is there a shorter way of achieving the same thing?

Hello @Detlef Lewin,Just to satisfy my curiosity, this is the equivalent of the INDEX-MATCH formula using LOOKUP-PI.=LOOKUP(PI(),2/(1/COLUMN(B2:Z2)=AGGREGATE(14,4,1/COLUMN(B2:Z2)*((B2:Z2)=1),1)),B1:Z1)Indubitably, INDEX-MATCH formula is preferred but the foregoing formula satisfied my curiosity!