Notifications
Clear all
Topic starter
The attachment has 2 columns of codes
And I need to check which codes from column A do not exist in column C
The problem is that the codes are not accurate.
I'd love to get a solution thanks
Posted : 05/03/2019 10:06 am
Hi Lea
In cell D2 enter
=VLOOKUP(SUBSTITUTE(SUBSTITUTE(A2,"-0",""),"(---)","")&"*",C:C,1,FALSE)
Copy down as many rows as needed.
What I am doing is to remove unwanted (extra) characters from column A.
I then need to do a wildcard match (using the asterisk *) as some codes in column B ends with -SF (like in row 507)
Hope this helps.
Sunny
Posted : 05/03/2019 8:56 pm