Not Equal To Multiple Criteria

Hello,

I have this formula below where I am trying to build a data validation list based off of a set of data within a file. Currently the formula below is excluded any item that is showing with a "Gross" designation. I need to add more criteria to exclude. Is there an easy way I am not seeing? I need <>"Gross"; <>"Specialty"; <>"Fixed; <>"% in lieu". I would like to avoid having the formula get much larger than it already is and was hoping there was a way to just string the <> to's together in the existing formula somehow?

=IF(IFERROR(INDEX('Tenant Tax Recovery Summary'!$B$8:$B$10000,AGGREGATE(15,6,(ROW('Tenant Tax Recovery Summary'!$B$8:$B$10000)-ROW('Tenant Tax Recovery Summary'!$B$8)+1)/('Tenant Tax Recovery Summary'!$E$8:$E$10000<>"Gross"),ROWS(AL$4:AL5))),"")=0,"",IFERROR(INDEX('Tenant Tax Recovery Summary'!$B$8:$B$10000,AGGREGATE(15,6,(ROW('Tenant Tax Recovery Summary'!$B$8:$B$10000)-ROW('Tenant Tax Recovery Summary'!$B$8)+1)/('Tenant Tax Recovery Summary'!$E$8:$E$10000<>"Gross"),ROWS(AL$4:AL5))),""))

Try this untested...

Put your key words (Gross Specialty Fixed etcc) in a range of cells, say Z1:Z4
Then replace both instances of
('Tenant Tax Recovery Summary'!$E$8:$E$10000<>"Gross")
With
(ISNA(MATCH('Tenant Tax Recovery Summary'!$E$8:$E$10000,$Z$1:$Z$4,0)))

That worked like a champ! Thanks!

Here is the adjusted formula.

=IF(IFERROR(INDEX('Tenant Tax Recovery Summary'!$B$8:$B$10000,AGGREGATE(15,6,(ROW('Tenant Tax Recovery Summary'!$B$8:$B$10000)-ROW('Tenant Tax Recovery Summary'!$B$8)+1)/(ISNA(MATCH('Tenant Tax Recovery Summary'!$E$8:$E$10000,$AP$4:$AP$11,0))),ROWS(AL$4:AL4))),"")=0,"",IFERROR(INDEX('Tenant Tax Recovery Summary'!$B$8:$B$10000,AGGREGATE(15,6,(ROW('Tenant Tax Recovery Summary'!$B$8:$B$10000)-ROW('Tenant Tax Recovery Summary'!$B$8)+1)/(ISNA(MATCH('Tenant Tax Recovery Summary'!$E$8:$E$10000,$AP$4:$AP$11,0))),ROWS(AL$4:AL4))),""))

Where AP4 through AP11 contains Gross, Specialty, Fixed, % in lieu, CAMB, TOE, Direct and Anchor.

You're welcome.