Look up value

[KevinDuque]

Raw Data
CM Name White Red Blue
Danice 1 1 1
Danice 1
Janice 1 1 1
Janice 1 1 1
Janice 1 1 1
Lyka
Melissa 1 1 1

Output
Janice Danice Lyka Mellisa
White Missing Incomplete Incomplete Completed
Red Completed Completed Incomplete Completed
Blue Missing Incomplete Incomplete Completed

Rule for the output
1. regardless how many times the name appears if theres something missing it under any color it will be tagged as Incompleted
2. if all are populated the it is set to 1
3. if all fields are missing it will be Missing

[KevinDuque]

I have attached the file for clear picture

[KevinDuque]

I appreciate any help you could provide

[KevinDuque]

I would need formula to come up with the output of Comlete, Incomplete, Missing

[Pepe Le Mokko]

We advise you not to 'bump' (reply to) your own posts too quickly after posting, unless you are posting some sort of clarification. Since bumped threads have replies, they will no longer appear in the "Zero Reply Posts" listing, which many members use to look for unanswered questions. If you do bump, limit it to no more than once every day. Remember that your best helper may be asleep on the other side of the world.

[KevinDuque]

Thank you Im really sorry just new to this forum. Will make sure it will not happen again..

[Cobra17]

put his in "I15"

what you are trying to do doesn't need a macro.