Opposite of match function

[Moh303]

Hi,

I need a formula that returns the header of the column that does NOT contain a certain text.

This is what I managed =INDEX(E1:G1, MATCH("n/a",E2:G2,0)).

Which basically gives me me the opposite of what I need.

Note. There is only one cell that does not contain the text "n/a".

Thank You in advance.

[daddylonglegs]

You can use an "array formula"

=INDEX(E1:G1,MATCH(TRUE,E2:G2<>"N/A",0))

confirmed with CTRL+SHIFT+ENTER

...or add an INDEX function and you can enter normally

=INDEX(E1:G1,MATCH(TRUE,INDEX(E2:G2<>"N/A",0),0))

[Moh303]

That works perfectly, really appreciate it.

However, I'm hoping I could trouble you again by helping me understand how that works. Im not familiar with the <> sign, or the need of the CTRL + **** = ENTER for the first formula.

Thank you