Extract single numeric ID and name attached to another numeric ID and name

I have four columns, first two have a numeric ID and corresponding name respectively and the second two columns have second kind of numeric ID and related names. Both numeric IDs and names may or may not be duplicate. For ID I, there may be multiple ID II and their names. However for ID II, there should be a single ID and customer name attached to it. To map single accounts to ID II, need to remove the multiple accounts attached to ID II, whose names in col 2 do not match the names in col4 well. VLOOKUP with approximate match will not be able to find out the numeric ID and name that best suits to ID II. Is there any way to use NLP, Excel or SQL to find out the unique ID I and name attached to ID II and the name II

© Copyright 2013-2019 Analytics Vidhya