Hello,
Having a curious new problem: Have an Index Match formula working, but the issue is that Excel is not recognizing the names I need when I type them...only when I copy and paste from the list of names.
Very strange because it is completely unformatted text, formatted as text, and the cells look exactly the same when I copy and paste or type it out myself. But the exact function returns False when I copy and paste in one cell and type in the other!
So for example:
"John James" copied and pasted into cell B1 from the list of all names in Column A, is not recognized as equal to my typing of "John James" in B2.
Anything else I can fix — tried this in a different notebook but got the same result. Thought the cell formatting would fix it, but nope. Thanks!
Bookmarks