Sep 03 2022 02:18 AM
I need a help! I have a scenario where if i type a number then it should give me a corresponding coded value based on alpabet on another column. see below screenshot.
Numbers from 1 to 0 are coded using word BLACKWHITE
Where B=1, L=2 etc.
Sep 03 2022 02:51 AM
Solution@Lionel Charley Use below formula-
=CONCAT(XLOOKUP(--MID(N3,SEQUENCE(LEN(N3)),1),$C$3:$L$3,$C$2:$L$2,""))
For dynamic array approach try-
=BYROW(N3:N7,LAMBDA(x,CONCAT(XLOOKUP(--MID(x,SEQUENCE(LEN(x)),1),C3:L3,C2:L2,""))))
Sep 03 2022 03:34 AM
You are awesome. @Harun24HR. Perfect!. Thank you for the help.
Sep 03 2022 05:30 AM
Sep 03 2022 02:51 AM
Solution@Lionel Charley Use below formula-
=CONCAT(XLOOKUP(--MID(N3,SEQUENCE(LEN(N3)),1),$C$3:$L$3,$C$2:$L$2,""))
For dynamic array approach try-
=BYROW(N3:N7,LAMBDA(x,CONCAT(XLOOKUP(--MID(x,SEQUENCE(LEN(x)),1),C3:L3,C2:L2,""))))