Vlookup errors

Hi,

sorry for late response, somehow, I wasn't notified about your response.

As Hans already pointed out, it seems there is a space in column A, but not in your column E. Space is equal to any other sign or letter in Excel. It often causes issues when we compare the two cells. If you have A_ and A with space at the end, Excel considers it as two different contents.

You can check if this is the case, by comparing two same phone numbers - so take 1 from column A and compare it to the same phone number in the column E.

To compare the content of two cells, you can simply use = (equals) sign, as presented below:

In the first example there is space before phone number and when comparing it to the one in my column C, I get result “FALSE” - meaning the content in compared cells is not exactly the same.

So, there are many solutions to this. Two were already presented by Hans. In his solution he instructed VLOOKUP to search for space plus content of selected cell => =VLOOKUP(" "&E3, $A$3:$B$6431, 2, FALSE). Or in his other suggestion, you can look for »anything« which is indicated by * sign plust content of selected cell => =VLOOKUP("*"&E3, $A$3:$B$6431, 2, FALSE).

Alternatively, you could also use TRIM function, which cleans all unnecessary spaces from the cells. See below:

Let me know if you succeeded.