"Match & Index" or "LookUp" to look up values

[fahadalambd]

Hi all,

Hope you guys are well. Please check the attached pic.

I need to find out the value of "Stock Code" from "Table 1" to "Table 2". Is there any ways I can do it?

Thanks in advance

 

[gifariz]

If you use Office 365 (support dynamic array), try this in B16:

=TEXTJOIN(",",TRUE,LOOKUP(TEXTSPLIT(A16,","),B$3:B$9,A$3:A$9))

 

[fahadalambd]

Sorry mate, the above script isn't working in "Excel OFFICE 2016" . However, it is working in "Excel OFFICE 365" perfectly

Do you know how to use this formula in "Excel Office 2016"?

Thanks in advance

 

[gifariz]

Sorry I dont know for office 2016