In column A locate partial text from column C then apply corresponding column D text to column B

[Krikit256]

Hello

I have Windows 11 and Office 365. I have included a screenshot because corporate will not allow me to install the XL2BB tool.

I have a long list of email addresses in column A. I need to know the person’s parent company.
In column C I have a list of text strings that might be in one of the (col A) email addresses. In column D, I have the corresponding Parent Company.

I would like Excel to search all email addresses in col A, find a match in col C and apply the Parent Company (col D) to column B (next to each email address.).

My column A list will change each month, and I will add to columns C & D as more come in.

Currently, column A is A2 to A473, columns C & D are 2 to 58.

Do I need my lists to be tables? Do I need helper cells? Do I use a search or filter or lookup formula?

Thank you in advance for suggestions and help on this. I am not an advanced Excel user, and I feel as though I have read every post, looked at every similar question on this site, and watched one million tutorials. I cannot figure out what I need.

Again, thank you!

 

[hagia_sofia]

Provided that all those email addresses have the same structure as in this picture (i.e. chain + dot + something) and there are no duplicates in column C with different companies in column D:

=XLOOKUP(TEXTBEFORE(A2:A12,"."),C2:C12,D2:D12,"not found")

If it is more complicated post more examples.

 

[Krikit256]

Provided that all those email addresses have the same structure as in this picture (i.e. chain + dot + something) and there are no duplicates in column C with different companies in column D:

=XLOOKUP(TEXTBEFORE(A2:A12,"."),C2:C12,D2:D12,"not found")

If it is more complicated post more examples.

This was so simple and yet ellusive to me due to my lack of Excel knowledge. This formula works perfectly.

I greatly appreciate your help and quick response.
Thank you!

 

[hagia_sofia]

This was so simple and yet ellusive to me due to my lack of Excel knowledge. This formula works perfectly.

I greatly appreciate your help and quick response.
Thank you!

Glad to help!