So I have an excel spreasheet. There is a Customer Column which shows the 'Account Code - Customer Name' .
The Account Code is between 6 and 8 digits.
I need to check to see whether this account code appears on a different list. if it does, then a yes appears.
I am struggling to do it, as the account code is the same number of digits for each line.
Any ideas? Thank you
