Can I match values from a table in excel to observations in my data?
Let me describe what I have first to hopefully provide a clear picture of my issue. I have a data set with individual people and how long they have worked with an organization. I also have a pay table (separate file) that provides monthly salaries based off rank in organization and time with organization (Row titles: rank; column titles: time). What I am trying to do is match a person's monthly salary from the pay chart to their observation in my data. Is that possible?
Let me describe what I have first to hopefully provide a clear picture of my issue. I have a data set with individual people and how long they have worked with an organization. I also have a pay table (separate file) that provides monthly salaries based off rank in organization and time with organization (Row titles: rank; column titles: time). What I am trying to do is match a person's monthly salary from the pay chart to their observation in my data. Is that possible?
Comment