Array Formulas not necessary

[Tolle]

I was asked to help my boyfriend on a vlookup with multiple conditions. I know that requires using Index Match and using them as an array formula. However when he went to hit "enter" he didn't want to use "ctrl, shift, enter" as I told him but it still ended up working. At work today I checked another formula to turn back the second value from a vlookup instead of the first, something I also know needs array formulas. And again, the ctrl shift enter wasn't necessary.

The formulas in question are below

=index(A:A,match(1,(B:B=F2)*(C:C=G2),0))
=INDEX(Invoice!D:D,SMALL(IF(Invoice!F:F=B2,ROW(Invoice!F:F)),2))

Does anyone know why it is working without telling excel it is an array formula?

 

[Fluff]

It's to do with when updates are released, people on the Monthly (targeted) channel now have the new Dynamic Array functions, but those on the Monthly Channel don't as yet.
I suspect that you won't have them either. If you had that would explain why you don't need to use CSE anymore.