Our company operates in 2 countries with different rates of pay for personnel in each.
Part of my spreadsheet requires the looking up of pay rate based on the employees occupation and the country. I have been try to do this with Vlookup but I am beginning to believe this is not the correct function. The spreadsheet contains a cell with the employees countryand I would like to use value in this field to determine which pay scale to use.
Suggestions would be sincerely appreciated
Part of my spreadsheet requires the looking up of pay rate based on the employees occupation and the country. I have been try to do this with Vlookup but I am beginning to believe this is not the correct function. The spreadsheet contains a cell with the employees countryand I would like to use value in this field to determine which pay scale to use.
Suggestions would be sincerely appreciated