Chrisfav89
New Member
- Joined
- Feb 28, 2017
- Messages
- 10
Hello,
I have been trying to pull some data via Index(match. The match function is not working and I'm not sure why. I can see there should be a match and cannot figure out why.
I've fiddled with the cells format each individually, then by Text to Columns.. No luck.
I asked excel if the two cells = each other and the output was "false" as expected. Then I asked excel if each cell was text (ISTEXT) and the output was "true" for each cell.
So if excel is telling me they are both text, and I can see that the numbers match identically. I've confirmed there are no random spaces in each cell.
Now I'm puzzled as to why the match function won't work.. Any ideas? Has anyone ran into this issue before?
Thanks
I have been trying to pull some data via Index(match. The match function is not working and I'm not sure why. I can see there should be a match and cannot figure out why.
I've fiddled with the cells format each individually, then by Text to Columns.. No luck.
I asked excel if the two cells = each other and the output was "false" as expected. Then I asked excel if each cell was text (ISTEXT) and the output was "true" for each cell.
So if excel is telling me they are both text, and I can see that the numbers match identically. I've confirmed there are no random spaces in each cell.
Now I'm puzzled as to why the match function won't work.. Any ideas? Has anyone ran into this issue before?
Thanks