I have a VLOOKUP issue
The formula is correct
The data that is in column 1 of the table can be a string of numbers, or, letters mixed with numbers.
If I look at a cell in column 1 of the table and then manually type it back into the same cell, then the formula finds the value
This leads me to believe that the data in column 1 of the table has a formatting issue (I guess)
So I have tried to reformat as numbers, text, general and that does not help
I have also tried to clear formatting of all data in that column and that does not help either
But if I put the cursor in front of the first character in one of the cells and press enter, not only does the data move to the right of the cell, it is also found using the formula
I have never run into anything like this before.
Hopefully someone has and knows the fix for it
The formula is correct
The data that is in column 1 of the table can be a string of numbers, or, letters mixed with numbers.
If I look at a cell in column 1 of the table and then manually type it back into the same cell, then the formula finds the value
This leads me to believe that the data in column 1 of the table has a formatting issue (I guess)
So I have tried to reformat as numbers, text, general and that does not help
I have also tried to clear formatting of all data in that column and that does not help either
But if I put the cursor in front of the first character in one of the cells and press enter, not only does the data move to the right of the cell, it is also found using the formula
I have never run into anything like this before.
Hopefully someone has and knows the fix for it