Forum Discussion
Solved
Excel Query
Hi Team, In Column C are parts name and in Column D (yellow Highlighted) are sequenced of arriving them ( mentioned in cell E4,F4,G4). Since VB1 arrives on 1/1/2021 so it's sequence 1,1,1...
Use XLOOKUP() with BYROW() function like
=BYROW(E5:G23,LAMBDA(r,TEXT(XLOOKUP("z",r,$E$4:$G$4,,-1,-1),"d")))Only XLOOKUP() in this way-
=TEXT(XLOOKUP("F",E5:G5,$E$4:$G$4,,,-1),"d")Or-
=TEXT(XLOOKUP("z",E5:G5,$E$4:$G$4,,-1,-1),"d")See the attachment
Use XLOOKUP() with BYROW() function like
=BYROW(E5:G23,LAMBDA(r,TEXT(XLOOKUP("z",r,$E$4:$G$4,,-1,-1),"d")))Only XLOOKUP() in this way-
=TEXT(XLOOKUP("F",E5:G5,$E$4:$G$4,,,-1),"d")Or-
=TEXT(XLOOKUP("z",E5:G5,$E$4:$G$4,,-1,-1),"d")See the attachment