Compare 3 columns in excel

[Freeman2022]

Hello,

I have a list of numbers in column A listed as Customer numbers, also in columns C,D,E are customer numbers. What I'm trying to do is if Column A info is found in column C,D or E, then Column F is Contacted, if not then not contacted.

Thanks in advance

I'm using excel 365

 

[Freeman2022]

But how would you know which of them had been contacted?

Maybe I should explained that part more, it didn't matter which one was contacted in C-E because they are linked via Child\Parent Relationship, so as long as ONE of them were found, Contact took place somewhere in that hierarchy. Thanks for all your help though, I should have explained better

 

[Fluff]

Not a problem & we got there in the end.