Hi,
I'm in need of assistance with the Index Function to search for words within a string with a reference from another sheet. match the values and retain them.
Table 1 contains the following words;
Table 2 contains the word strings;
The formula [=IFERROR(INDEX(CodeList,MATCH(1,COUNTIF(A9,"*"&CodeList&"*"),0)),"")] I'm using is not giving the desired result.
Therefore, I need assistance with the formula where it should search the string and retain all the words recognized from Table 1.
I am looking forward to hearing from you.
Thanks,
Dev
I'm in need of assistance with the Index Function to search for words within a string with a reference from another sheet. match the values and retain them.
Table 1 contains the following words;
RRDC |
RRMF |
RROM |
SCAL |
XBOP |
EOL2 |
INCO |
Table 2 contains the word strings;
Order Status |
BLCA BLKD C2AP COM-GLA NoMP REL SCAL XBOP |
BLCA BLKD C2AP COM-GLA NoMP REL SCAL XBOP |
BLCA BLKD C2AP COM-GLA NoMP REL SCAL XBOP |
BLCA BLKD C2AP COM-GLA NoMP REL SCAL XBOP |
BLCA BLKD C2AP CFSL COM-ATP COM-FDL COM-GLA NoMP REL XBOP |
BLCA BLKD C2AP CFSL COM-ATP COM-FDL COM-GLA NoMP REL XBOP |
BLCA BLKD C2AP CFSL COM-ATP COM-FDL COM-GLA NoMP REL XBOP |
BLKD C2AP COM-GLA EOL0 EOL2 NoMP REL SCAL |
BLCA BLKD C2AP COM-GLA EOL2 NoMP REL SCAL |
BLCA BLKD C2AP COM-GLA EOL2 NoMP REL SCAL |
BLKD C2AP COM-GLA EOL0 EOL2 NoMP REL SCAL |
BLKD C2AP COM-GLA EOL0 EOL2 NoMP REL SCAL |
BLCA C2AP EOL2 NoMP REL SCAL |
BLKD C2AP COM-GLA EOL2 NoMP REL SCAL |
BLCA C2AP CFSL COM-GLA NoMP REL XBOP |
BLCA BLKD C2AP CFSL COM-ATP COM-FDL COM-GLA NoMP REL XBOP |
C2AP COM-GLA INC-VBEP-LDDAT INC-VBEP-MBDAT INC-VBEP-TDDAT INC-VBEP-WADAT INCO NoMP REL |
BLCA BLKD C2AP COM-GLA NoMP REL SCAL |
BLCA BLKD C2AP COM-GLA NoMP REL RRDC SCAL |
BLCA C2AP CFSL COM-GLA NoMP REL XBOP |
BLCA BLKD C2AP COM-GLA NoMP PRSE REL RRDC |
BLCA BLKD C2AP COM-GLA EOL1 NoMP REL RRDC |
BLCA C2AP COM-GLA EOL1 NoMP REL RRDC |
C2AP INC-VBAP-CEPOK INCO MDID NoMP REL RROM SCAL |
BLCA C2AP EOL2 INC-VBAP-CEPOK INCO MDID NoMP REL RROM SCAL |
BLCA BLKD C2AP COM-GLA NoMP REL RRDC SCAL |
INC-VBAP-CEPOK INC-VBAP-NETWR INCO NoMP PRSE REL |
BLKD C2AP COM-GLA INC-VBAP-ROUTE INCO NoMP REL |
BLKD C2AP COM-GLA EOL0 EOL2 NoMP REL SCAL |
The formula [=IFERROR(INDEX(CodeList,MATCH(1,COUNTIF(A9,"*"&CodeList&"*"),0)),"")] I'm using is not giving the desired result.
Therefore, I need assistance with the formula where it should search the string and retain all the words recognized from Table 1.
I am looking forward to hearing from you.
Thanks,
Dev