Lookup and return cell value

I am currently trying to create a report that, from the attached data, summarized the amount of revenue by state by customer. I am assuming I will need a lookup of some kind. So I think I am looking for a formula that looks at a portion of the spreadsheet and finds the abbreviation for a state, then returns that revenue amount to the left of it. I need help. I am open to any suggestions.

Thank You in advance