Lookup Value error only some matching despite same cell values

Question

Any idea why this would happen? All cells are the same, yet lookup value isn't working for all of them?&nbsp;

hotchilli · Answer

Usually caused by spaces or hidden characters.&nbsp; Try cleaning, trimming the column

Forum Discussion