
Originally Posted by
mickgibbons1
Hi dave
thank you once again, when i apply this formula to Column O on sheet one im still getting matchs that i know are not there, can you suggest anything?
That's because your values in column B sheet2 have a trailing space behind them all which is why I had to use trim in the original solution.
Trim those values and you will get the results you want in sheet1.
You can trim using either this formula =TRIM(B1) then drag down and copy and paste as values over the contents of column B, or place this code into VBA and run the macro after highlighting the contents of column B
Bookmarks