Partial Match Formula - Duplication check

[Curioxity]

Hello,

I'm looking to produce a simple (well I say simple, I've been playing with this for a while and just can't get it right) comparison workbook where I can copy/paste an extract from our own internal systems of company names and unique IDs in one sheet.

Then in another I'm entering details of companies that we're asked to add to the system to establish if they are already on by matching them against this extract so we can avoid duplication.

I tried running partial left matches that stop at spaces but that doesn't work well with companies that have words like 'The' in their name so I'm wondering if there's any way to add an 'exclusion' rule to match formulas?

Also once that match is run, I'd like it to pull the IDs from that initial database sheet and place them next to their respective match on the potential new companies list. I hope that makes sense.


I'd also like to add a form button to export that one sheet of comparison information to a new workbook that I can send off to others - although I think that might be the easiest part of all this.

Many thanks!

 

[inactiveuserps07]

@Curioxity, it sounds like you just need to add the asterisk wildcards to your MATCH lookup_value (i.e., "*"&lookup_value_cell_reference&"*"), and then set the match_type parameter to 0 (for exact).