If your mini example values are in cells A3:D7, you might
want to use something like

=INDEX(D3:D7,MATCH
("Facilities"&"access"&"none",A3:A7&B3:B7&C3:C7,FA LSE))

[entered as array formula with CTRL + SHIFT + ENTER] to
retrieve the value "not required".

HTH,
Bernd