LinkBack URL
About LinkBacks
Hello. I'm copying the EXACT value from a column and then trying to match and it's not working. This is my formula. =MATCH(E3,Sheet1!C:C,0) Is it maybe because the format changed when I copied it?
Hello. I'm copying the EXACT value from a column and then trying to match and it's not working. This is my formula. =MATCH(E3,Sheet1!C:C,0) Is it maybe because the format changed when I copied it?
In the column it says text, but when I copy it says general. This is how it looks 100278-5031
I may be able to help you out with this but I'm going to need to see your Excel file.
you may have a space or other invisible character in either of the match values
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
In this instance, the formatting doesnt really matter, that is text data, not a value. As Ron says, look for leading/trailing spaces.
If you know you have 2 entries that you think are the same, testthem with =exact()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
You could also use the LEN function to compare the length of each cell contents. eg: =LEN(A2) =LEN(D12) if those are the cells that are supposed to be a match, the LEN will be the same if they match.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks