Lookup multiple items

[YasserKhalil]

Hello forum experts
I have data in column A & B (Code and description)
For example : Apple has the code 15

In column C I have multiple items in one cell and need to extract the code for all these items and get the results concatented
For example : for the following items (Mango,Apple,Banana) I need to extract the codes in column D to be like that (18,15,17)

Thanks advanced for help

[millz]

Try:

Please Login or Register  to view this content.

[YasserKhalil]

Thank you very much Mr. Milz
That's wonderful and working exactly as I need
Best Regards

[jindon]

UDF
=IndexMulti(C2,",",$A$2:$B$5,2,1)

Please Login or Register  to view this content.

[YasserKhalil]

Thanks a lot Mr. Jindon for this great UDF
That's awesome too