AlexEanbuCopper ContributorOct 03, 2023Which Month Belong to the ArrayHere I have Attached Work book below,how can I sort it outWORK BOOK.xlsx10 KB
2 RepliesReplies sorted by NewestHansVogelaarMVPOct 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.AlexEanbuCopper Contributor to HansVogelaarOct 03, 2023THANKS BRO
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.
