I would just use a formula for what I think you are trying to do. If you have a table of materials and its suppliers, and in another table, you want to show the supplier for the material you have entered, try something like this:
=LOOKUP(G2, $A$2:$A$10, $B$2:$B$10)
G2 would be the cell with...