This is probably a very basic question for you boffins but I am stumped!

I have a sheet wherein I enter details of orders received from customers (columns are: date, order no., customer name, product no., size, colour, quantity, price, total amount).

Different customers pay different prices so I want the price for a specific customer to auto insert once I have entered the customer name and product details.

I'm sure this is possible but because I don't know what the action is called I can't look up the tutorial!

Help please!