Simple Text Searching Macro

%3CLINGO-SUB%20id%3D%22lingo-sub-304499%22%20slang%3D%22en-US%22%3ESimple%20Text%20Searching%20Macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304499%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20problem%20is%20simple%20in%20design%2C%20but%20I%20won't%20comment%20on%20the%20difficulty%26nbsp%3Bof%20execution.%3C%2FP%3E%3CP%3EIn%20summary%2C%20I%20need%20to%20match%20data%20from%20two%20columns%20of%20data%20with%20the%20corresponding%20data%20in%20a%20separate%20two%20columns%20of%20data.%20The%20data%20is%20just%20a%20text%20string%2C%20specifically%20the%20name%20of%20a%20company%2C%20and%20a%20location%20(city%2C%20state).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EManually%20I%20accomplish%20this%20by%20looking%20at%20the%20raw%20data%20here%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F63268iFB8C41675A9B8E49%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Screenshot%202018-12-19%2020.55.58.png%22%20title%3D%22Screenshot%202018-12-19%2020.55.58.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20the%20first%20line%20I%20see%20that%20it's%20Company%20AAA%2C%20located%20in%20Washington%2C%20D.C.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20then%20turn%20to%20the%20other%20set%20of%20data%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F63269iBF4A3CE735EAC64F%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Screenshot%202018-12-19%2020.53.08.png%22%20title%3D%22Screenshot%202018-12-19%2020.53.08.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIf%20company%20AAA%20is%20listed%20here%20AND%20the%20city%20for%20that%20particular%20company%20is%20as%20well%2C%20I%20delete%20the%20original%20row%20of%20data%20I%20started%20with.%20If%20not%2C%20I%20abandon%20the%20search%20for%20this%20first%20data%20set%20and%20move%20back%20to%20the%20raw%20data%2C%20and%20repeat%20for%20the%20next%20line.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBy%20way%20of%20another%20example%2C%20you%20will%20notice%20that%20Company%20C%2C%20in%20both%20Nashville%20and%20Memphis%20are%20in%20both%20data%20sets%20and%20therefore%20would%20be%20deleted%20from%20the%20first.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20understand%20the%20basic%20idea%20of%20several%20loops%20with%20nested%20conditional%20statements%20but%20I'm%20far%20more%20interested%20in%20having%20someone%20produce%20this%20straightforward%20macro%20for%20me%20instead%20of%20spinning%20my%20wheels%20learning%20this%20specific%20language.%20Obviously%2C%20I%20would%20pay%20for%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20someone%20think%20they%20can%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-304499%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Emacro%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

My problem is simple in design, but I won't comment on the difficulty of execution.

In summary, I need to match data from two columns of data with the corresponding data in a separate two columns of data. The data is just a text string, specifically the name of a company, and a location (city, state).

 

Manually I accomplish this by looking at the raw data here:

Screenshot 2018-12-19 20.55.58.png

 

On the first line I see that it's Company AAA, located in Washington, D.C.

 

I then turn to the other set of data:

Screenshot 2018-12-19 20.53.08.png

If company AAA is listed here AND the city for that particular company is as well, I delete the original row of data I started with. If not, I abandon the search for this first data set and move back to the raw data, and repeat for the next line.

 

By way of another example, you will notice that Company C, in both Nashville and Memphis are in both data sets and therefore would be deleted from the first.

 

I understand the basic idea of several loops with nested conditional statements but I'm far more interested in having someone produce this straightforward macro for me instead of spinning my wheels learning this specific language. Obviously, I would pay for this.

 

Does someone think they can help?