Need a simple lookup formula for excel

Job ID: 32882085

Budget: $10 – $30 CAD

We have 4 tables. 1 table is the result table. We have to look up a value that is in table 3, find it in table 1 and replace it with the value of table 2 into table 4.