Why do Index and Match do not work when you've multiple numbers in Cell

[nsa1]

Hello,

I am trying to figure out if Index and Match function can work for indexing numbers separated by "," to be assign..

See the snapshot below

Thanks,
NA

 

[nsa1]

Same Error in a new clean sheet
View attachment 96972

 

[DanteAmor]

Note1:
Make sure you save your file as an "Excel Macro-Enabled Workbook (*.xlsm) and answer the "do you want to enable macros" question as "Yes" or "OK" (depending on the button label for your version of Excel) the next time you open your workbook.

Note2:
I am not seeing something in your images.

Note: 3
I share my file for you to download on your computer. Remember to answer Yes to enable macros when you open the file.
In row 2 from cell E2 you will see the results that the IndexWithComma function returns.

index comma.xlsm

drive.google.com

Regards
Dante Amor