Dear All,

I am new to this forum and hence its possible that my question is repetitive. I have a list of customers which have presence in multiple districts. Against this customer list, I need to pull up all the districts they reside in. Eg:

Column A Column B Column C Column D

Company XYZ District 1 District 2 District 3


Can anybody please guide how this can be done? Is it a combination of countifs and index?

Any help would be much appreciated.

Thanks,
F