IF function - display cell from another worksheet

That is awesome Josh thank you! That formula is great for the basic pricing!

However, the main issue that I am trying to address is we have many customers with different pricing. I am trying to link to the worksheet with specific customer pricing. I am attaching my basic spreadsheet, maybe you can see a way for me to do this effectively.