VBA code to look up and paste values from another open file

Job ID: 35674835

Budget: $30 – $250 USD

I am looking for somebody to help me create this macro. The piece of work is urgent so I would like to award the job ASAP.
I need some VBA code to look up 2 values (home team and away team) and then if cell on same row (home score) is empty > paste data from another open excel file into various cells in that row
Related categories: Visual Basic Excel