I have a question regarding formulas in Excel (2013). Please excuse my novice level of Excel formula usage.
I have data in a worksheet such as:
Column A = Old Cust ID
Column B = New Cust ID
I am trying to find matches using this formula (simplified for conversation sake):
Not sure if this matters, but the data source for the A column is a SQL DB. The data source for the B column is an Access DB.
Oddly enough, this formula work s all of the time on one worksheet, but if I copy the cells and formula to a new worksheet, things get weird as I described.
Sometimes, I can click in the cells that contain the matching data that I can clearly see, and Excel appears to 'format' the contents of the cell by shifting it right if it is left, so not sure if this may be a factor. The Number Format is set to General on all cells.
Can someone tell me what I might be doing wrong? Could this be some hidden formatting due to the different data sources used for the import?
Here is the actual formula that works:
On another worksheet, I'm also trying to perform the inverse, but this formula does not work:
This is the problem that led me down this rabbit hole.
Any insight would be greatly appreciated. Thanks in advance for your expertise!