Forum Discussion
Help me complete the formula
Hello, The formula works almost correctly but the issue with the last row. There is the code 190#93#91#25#12#17 and I need to do that if the last number ( in this example 17) missing in the colu...
If you'll only need the penultimate number, you can use
=LET(cat,TEXTSPLIT(B2,"#"),XLOOKUP(--INDEX(cat,COUNTA(cat)),$E$2:$E$5,$F$2:$F$5,XLOOKUP(--INDEX(cat,COUNTA(cat)-1),$E$2:$E$5,$F$2:$F$5)))
If you might need to search further back, it would be better to use LAMBDA.
Thank you very much! It works for me.