Separate values from linked cell



I am trying to build pricing data for our members and I can get to the point where I have a specific number for each carrier inside our package, but I am not sure how to separate these values or link them one cell at a time. For example, I have a member that has the product a, b, c, d, e, f, and g. I have linked these to my current spreadsheet, and in the next cell, I use the Lookup field type, and I get the costs for each product. How do I separate these values, or find the pricing for each product so that I can export and see the individual costs for each member without having to manually enter the prices?