Quote:
Originally Posted by xor
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.
|
Hi,
yes so two things... as my file was big could not send everything. second, it could be a possibility that if you in specific code and there is no data for that country in second sheet. The data is i am referring her is Base Salary market data and not employee data. I hope this explains. Thank you