Formula help

Copper Contributor

Hi,

Im needing to find a formula that will look for the first occurrence in each row of a number (in this case 12434, 12351 or 12363 which must fall AFTER 42002. If it occurs before, it is disregarded. On the first occurrence in each row of these numbers after 42002 I need to know the first date they occur (in column G). Would anyone be able to assist with the correct formula for this? It would be much appreciated :)

 

          A                  B                   C                 D                   E                  F                   G

01/01/202202/01/202203/01/202204/01/202205/01/202206/01/2022Result
42002420021243412434124341243403/01/2022
42002420024200212351123511235104/01/2022
12351123511235142002420021235106/01/2022
42002420021236312363123631236303/01/2022
1 Reply

@KTB01 

That could be

=INDEX( $A$1:$F$1, XMATCH(42002, $A2:$F2,,-1) + 1 )

as here

image.png