Excel formulae created and inserted to search for some criteria and apply a multiplication value

I have an excel spreadsheet of 980 items with item costs and a supplier category against each item code. I need a formulae set up in 4 sell price columns to search the supplier category and apply a multiplication number (different multiplication numbers are applicable for different categories). The right multiplication number will need to be applied to the cost to create the four different sell prices for each product.