Good morning,
I am trying to compare values in multiple sheets. Problem is the values generated from multiple databases is not identical. The ID has leading zeros in one, and not in the other; values generated are text in one and code in the other.
A combination of if and vlookup does not seem to work as I need to get a true or false in a third worksheet that I can give them as validation.
The formula I am trying to use is in the cell, as text which might help you point me to correct it.
Thanks in advance,
Bookmarks