MATCH or Macro? Populate Email Address Based On Data in Column

[kraamerica]

I have a sheet where the data changes daily based on certain parameters (overdue dates). I need a way to pull the email address associated with the data in the specific column (cell) to populate in another column in the same row so that I can send a specific email to specific people instead of a blanket to over 180 locations (and obviously have to go through and try to find their email address from memory or one at a time).

I can put all the email data in one sheet and just copy the daily sheet I receive if that's easiest. I'm not sure what data I can show or send to this forum for an example. Is a screenshot the best way? or the excel sheet itself?

Column A is an associated code, B is the Name of the location that I need the email address mapped to (or vice versa). C-G contain dates/reference numbers.

 

[kraamerica]

An alternative solution would be to bring both tables into Power Query/Get and Transform and merge the two tables joined on the DLR Name and Name fields to get the email address. If you would like to see this solution, then instead of pictures (I cannot manipulate pictures), load each sample table to this site using XL2BB.

I would very much like to learn this method and will get this to you tomorrow. Thank you.

 

[kraamerica]

Hope it works for you. Good luck.

Is there a way to expand the searchable data in the contact list by changing a number in the formula? I noticed that it only hits X amount of rows. I have about 180 contacts but it stops somewhere in the 100 row area.

 

[kraamerica]

Is there a way to expand the searchable data in the contact list by changing a number in the formula? I noticed that it only hits X amount of rows. I have about 180 contacts but it stops somewhere in the 100 row area.

FIGURED IT OUT.