IF((and)) using data validation list

[Irvine Kinneas]

Hi and Good day,

I'd like to know on how can I formula a information using the below data:
- list of name eg: Brian, Kate, Steve, Nick @ G1:G4 [having a dropdown data validation>List of the name @ A1:C1]

How can i generate a "DONE" in D1 [using the dropdown list @ A1:C1 which can be select randomly].
- to enable monitor who did it task A1,B1,C1 while can ensure the task was complete showing "Done" in D1
- tried before but not sucessful using this formula --> =IF((AND(A1=G1:G4,B1=G1:G4,C1=G1:G4)),"Done", "In progress")

Currently Im using this formula as per below which the "done" only can appear if i specifically use "Yes".
=IF((AND(A6="yes",B6="yes",C6="yes")),"done","In Progress")

please feel free to ask more information if needed

[Pauleyb]

=IF(ISERROR(MATCH(A1,G1:G4,0)+MATCH(B1,G1:G4,0)+MATCH(C1,G1:G4,0)),"In Progress", "Done")