index, match using OR

[gtd526]

Hello,
Looking to add <>"FNGG" OR <>"TECL" in the following formula: I already have the <>TECL.
INDEX('2x3x'!$A$9:$A$30,MATCH(TRUE,INDEX('2x3x'!$A$9:$A$30<>"TECL",0),0))

Thank you

The Whole Enchilada.xlsm
	A	B	C	D	E
8	Symbol	Sector	Type	Shares	Cost
9	FNGG	FANGs Bull 2x	Long	1	$ 31.00
10	TECL	Tech 3x	Long	1	$ 22.77
11	DXQLX	Mthly NASD-100 1.75x	Long	1	$ 33.15
12	UBOT	AI & Automation 2x	Long	1	$ 12.30
13	SPXL	S&P 500 3X	Long	1	$ 63.03
2x3x

Cell Formulas
Range	Formula
B9:B13	B9	=IF(COUNTIF(Sectors!$A$2:$AAT$47,$A9)=1,INDEX(Sectors!$A$2:$AAT$2,MAX((Sectors!$A$2:$AAT$47=$A9)*(COLUMN(Sectors!$A$2:$AAT$2)))),"")
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Domenic]

Try the following formula, which needs to be confirmed with CONTROL+SHIFT+ENTER...

=INDEX('2x3x'!$A$9:$A$30,MATCH(TRUE,ISNA(MATCH('2x3x'!$A$9:$A$30,{"FNGG","TECL"},0)),0))

Hope this helps!

 

[gtd526]

Try the following formula, which needs to be confirmed with CONTROL+SHIFT+ENTER...

=INDEX('2x3x'!$A$9:$A$30,MATCH(TRUE,ISNA(MATCH('2x3x'!$A$9:$A$30,{"FNGG","TECL"},0)),0))

Hope this helps!

Thank you. I tried the array, but didn't have the ISNA.