I'm assuming there is only one price per state, and you want the price to appear next to the customers name (on the first sheet.

Try
=IF(ISNA(VLOOKUP(B5,Sheet2!$A$1:$B$6,2,FALSE)),"No Price",(VLOOKUP(B5,Sheet2!$A$1:$B$6,2,FALSE))
Where
B5 is the customer's stat
Sheet2!$A$1:$B$6 is the state/price matri

If you have prices for every state (and states for every customer) or don't mind seeing #N/A errors you can just use the vlookup part.