Array Formulas not necessary

Tolle

New Member
Joined
Aug 21, 2019
Messages
7
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?
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Welcome to the forum!

Because only one cell was selected so one result was returned?
 
Upvote 0
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?
 
Upvote 0
Are you both on Office 365?
If so, are you on the insiders program?
 
Upvote 0
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...
 
Upvote 0
What version of Excel are you both running?
 
Upvote 0
I am using office 365, but after some research don't think I am on the insiders program.
 
Upvote 0
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.
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,213,538
Messages
6,114,220
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top