In Cells E4-E9 the consultants work status should be displayed as either On leave or Available. The consultants that are On Leave are listed in column G (cells G4 to G6)

Use IF and COUNTIF to identify which consultants are On leave or Available for work by checking the list in column G (cells G4 to G6).

A B D E F. G H 1 Consultants on leave XXDASIL XXHUCHE XXJ ABRO 2 3 First Name Last Name Date Started Consultant ID Work status 4 David Silver 9/2/14 XXDASIL 5 Harriette Brown 8/11/15 XXHABRO 6 Hugo Chevi 11/11/19 XXHUCHE 7 Sally Chan 6/14/20|XXSACHA 8 Tyrion Smith 4/1/20 XXTYSMI 9 Jamie Brown 7/1/17 XXIABRO 10 11 12 13