Function to extract the data that matches the value in comma separated

[SBBmaster09]

I need a function in excel that extract the values like,

183,193

and return a specific column content.

So for example, in cell a1 it has 183,193. The function will get the first value 183 and find that matches the value in sheet2, column A has the id number and column B has the data, so once 183 is found in the sheet2, return the value that is in column B, same as 193, find 193 in the sheet2 of column A and return the column B.

So if 183 has found the apple, and 193 is mango it would return

apple, mango


hope some one could help me with this. thanks.

[jindon]

=VLookUps(A1,",",Sheet2!A:B,2)

Please Login or Register  to view this content.

[SBBmaster09]

I tried it but seems to be incorrect, please see attached file.

[jindon]

You have number as string in Categories!C.

Please Login or Register  to view this content.

[SBBmaster09]

that works fine, so great, thank you