Forum Discussion
Xlookup/Find row issue
Im looking up mostly numbers, but some of the numbers have a letter to start with. Example D53421 (the numbers with the letters got it in both the columns!)
Not sure why this happens though. I did check some examples and they did not have any space in front or back of the number.
Does the formatting mean anything?
SimenAlm Difficult to say. Can you upload an example of the values (numbers and/or texts) you are trying to match?
Otherwise, if you have two values for which you believe that they are the same, type a formula similar to this:
=A1=B1
If these two cells are indeed the same, it should return TRUE (SANN). If it does not, they are not exactly the same and your lookup function will not make the match.
Riny_van_Eekelen I did this test to make sure that it was indeed "SANN", and it was.
I checked cell J11961 up against C12450.
I've attached the document i'm working on. I deleted some columns though, but they don't matter in this case.
SimenAlm As suspected, your "Numbers" in column C are NOT real numbers, whereas the ones you were trying to match them with in column I are. Did a "Data / Text-columns" on C as "General". Now it works and you only have a handful of N/A's left.
Thanks!
I tried it myself and I can see that it now works perfect.
I thought it should be enough to "format" as numbers, but it obviously wasn't..