AlexEanbuCopper ContributorOct 03, 2023Which Month Belong to the Array Here I have Attached Work book below, how can I sort it out WORK BOOK.xlsx10 KB
HansVogelaarMVPOct 03, 2023AlexEanbu In K2: =XLOOKUP(J2, INDEX($B$2:$G$10,0,MATCH(I2,$B$1:$G$1,0)),$A$2:$A$10,"-") Fill down.
