lookup formula help

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.

 

Thank you.

By: J Mus

Leave a Reply

Your email address will not be published. Required fields are marked *