I have a matrix (Columns J-L) of names (Letters in the example) and corresponding values associate with the names. I have them currently reshown in a second matrix (Columns F-H). I want the second matrix (F-H) to show all the rows from matrix 1 as long as the name is not entered in column D. Entering a name into column D should make the corresponding row associated with that name in matrix 2 disappear. I am trying to do this using a FORMULA. I tried by seeing if each name = the column D as an array but that only works if the first value is true.

My spreadsheet shows what matrix 2 should look like in 3 different cases. Let me know if you need further information or have questions. Any help is appreciated. Thanks