Return Values From Tables Based On Conditions?

how to return values based on some conditions.

So for the sake of this example i have two cells lets call them J1 & J2 , one with the client name and another with State (matches the table name)

How can i get it so when i type in say Client 1 & Table 3 it will return the information in client 1s column into table 1s rate column. Obviously i want to be able to type in any clients name / table and have the same thing happen.

the red is what i want returned into table 1s rate column

Table 1
Table 1
Table 2
Table 2

[Code].....