How to find a value in a table

[ashoulds]

I need a function that would be able to tell the difference between the size,
color and material and spit out the order code for the option that fits. Any
ideas? An example of my table is below

(Size, Color, Material, Order Code)
2, B, R, 1
2, B, R, 2
2, B, P, 3
2, B, P, 4
4, R, R, 5
4, B, R, 6
4, R, P, 7
4, B, P, 8

 

[Sean Timmons]

Are the commas indicators of new column or is the entire list within one cell?

Also, there are multiple with the same Size/Color/Material. Presumably, you
want both order codes returned?

 

[ashoulds]

Commas indicate columns. There are 4 columns. There is only one order code
for each.