Vlookup formula

[rawr19911]

I need a way to look up any matchs in column B to column A in a different piviot however; column b has multiplle Id's and even if one matches i need it to pull in info
Example
Column B
XXX1, XXX2, XXX3
if anyone of them matches column a on the other chart such as
XXX2 Then i need it to bring back column C on the other chart-.... does this make sense? can i do it without spliting up my ID's on column B

 

[awoohaw]

@rawr19911
This forum has a tool, xl2bb (link below) that allows users to post mini worksheets of their data (anonymized). Please use the tool to post a sample of data and the cell(s) with the formulas that you are having problems with. Expected results would also be helpful.

If you cannot use the add in, then please post your data as table (labelling the rows and columns please).