Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >
AlexEanbuCopper ContributorOct 03, 2023Which Month Belong to the ArrayHere I have Attached Work book below,how can I sort it outWORK 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.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.
