I have one employees exel spreadsheet with location data. I have a second empployee excel spreasheet that lists if they are management level or not. Both spreadsheets have an email address field. I am trying to create an excel formula in the first spreadsheet that will look up the email address in the management level spreadsheet, and add it to a new column in the location data spreadsheet. I have tried lookup and vlookup but something is going wrong.
Again, the location data spreadsheet has employee email address and city, state, country. The management spreadsheet has email address and a column for management level yes/no.
By: J Mus