To, me there seems to be more problems here.

In Sheet1!E2 you write:

Need to Bring information here from Sheet 2. if you are in job 2554 and Argentina that bring in Column D values in here

The only Job Code 2554 in Sheet2 is in row 36, country PORTUGAL.

Another problem is that all country names in Sheet2 have a space after the last letter which the country names in Sheet1 do not have. This problem can be solved of course, but I think you should give examples (at least 5) in Sheet1 column E of expected results.