Forum

Notifications
Clear all

Cross-references inaccurate data between tables

2 Posts
2 Users
0 Reactions
146 Views
(@usb)
Posts: 244
Honorable Member
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
(@sunnykow)
Posts: 1417
Noble Member
 

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
Share: