Forum Discussion
Xlookup/Find row issue
SimenAlm Both your formulae are in principle correct. The #I/T error (#N/A in English) suggests that the value in C5 that you are trying to match via XLOOKUP or FINN.RAD (VLOOKUP in English) does not exist in column J. Note that there has to be an exact match, otherwise you will get #N/A error.
Are you looking up a number or a text? A number is not the same as a text looking like a number. A text with a space in front or behind is not the same as a text without the space.
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.