Compare two columns
Posted: Thu Dec 13, 2018 10:34 am
Hello, I need to compare two columns.
I have my product list, and I need to compare it with another product list to check if I have it at my place.
for example:
Somewhere in the column "A" will be a product ARTISTIC WAY WHITE STRUCTURE 20x40
The B1 cell is ARTISTIC WAY WHITE
Here should pop out that it occurs.
Names may vary slightly, the beginning is rather the same.
I need something like "Check if in Column A is the first 15 characters from cell B1"
Then drag it synchronously to B2, B3, B4 etc ...
It can be done?
I have my product list, and I need to compare it with another product list to check if I have it at my place.
for example:
Somewhere in the column "A" will be a product ARTISTIC WAY WHITE STRUCTURE 20x40
The B1 cell is ARTISTIC WAY WHITE
Here should pop out that it occurs.
Names may vary slightly, the beginning is rather the same.
I need something like "Check if in Column A is the first 15 characters from cell B1"
Then drag it synchronously to B2, B3, B4 etc ...
It can be done?