Formula is in cell D41 and I'm trying to match two names, one in the cell right next to it (C41) with another from another sheet "Daily SSA Phones" somewhere in Column R and then return the value that corresponds with the name on the same "Daily SSA Phones" sheet Column I. In other words, I want to find the name associated with the number of calls that person made from the "Daily SSA Phones" sheet. If there is no match, it should return a value of "-". Looking for feedback and/or suggestions on what I could be doing wrong since I'm not getting the correct value when I spot-check for accuracy.
It depends on which extra characters do you have. If you copy/paste your Daily SSA Phones from Web that could be nonbreaking spaces (unicode 160) or like. That could be spaces. First is to define which invisible characters do you have, after that use Ctrl+H to replace them on nothing. Perhaps formula also could be modified, but again, it depends on which symbols and where they are.