Duplicate Values

I'm running into issues with cleaning data within Excel files. I'm cross referencing two Excel spreadsheets to get accurate store locations. When I drop in my data (in column B) next to provided ...