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?

 

[Kenneth Hobson]

Welcome to the forum!

Because only one cell was selected so one result was returned?

 

[steve the fish]

All i can tell you is neither of those would work on my version without CTRL-SHIFT-ENTER. Are you sure you dont have an INDEX in there somewhere?

 

[Fluff]

Are you both on Office 365?
If so, are you on the insiders program?

 

[Tolle]

Welcome to the forum!

Because only one cell was selected so one result was returned?

But, for example, the first one had (B:B=F2)*(C:C=G2) that portion of the formula should have turned back an array which means Excel needs to be told, it always had but not today...

 

[Tolle]

As far as I know, no... but I am not sure what that means.

 

[Fluff]

What version of Excel are you both running?

 

[Tolle]

I am using office 365, but after some research don't think I am on the insiders program.

 

[Fluff]

Ok, if you click on file > Account > where it says "About Excel" what does the last line of that section say? Probably something like Monthly Channel, or Monthly (targeted) channel.

 

[Tolle]

Ok, if you click on file > Account > where it says "About Excel" what does the last line of that section say? Probably something like Monthly Channel, or Monthly (targeted) channel.

"Semi-annual Channel" why, what does that mean?