Activity Calendar - Cell won't populate (INDEX & MATCH related)

[greentea]

Hi guys,

A couple of years ago, I got your help in developing this tool to populate a promotional calendar. The user would enter values in the Data Entry tab and it would populate in the Calendar. I'm now trying to re-create again and the cells won't populate

In the example attached under Calendar, data should appear for Walmart Wks 34-37 & Costco Wks 40-43 but the cells are empty with no errors. I can't seem to identify the issue in my formula.

Thanks in advance for the help (again)

[xjohnson]

I think you need to make the formulas arrays by pressing ctrl+shift+enter in the upper left most cell. Then drag across and then down to fill the range.

[Glenn Kennedy]

...or... coerce into being a non-array formula:

=IFERROR(INDEX('Event Entry'!$N$6:$N$791,MATCH(1,INDEX(($A6&$B6&$C6='Event Entry'!$A$6:$A$703)*(AM$4>='Event Entry'!$K$6:$K$703)*(AM$4<='Event Entry'!$L$6:$L$703),0),0)),"")

[xjohnson]

Sorry Glenn has a better solution.

[greentea]

xjohnson ... omg that's embarrassing LOL

THANK YOU!

[xjohnson]

You're welcome good luck with your project!

[greentea]

Thanks GLENN, it worked

[Glenn Kennedy]

In terms of performance, it's no better... but if users are unfamiliar with array formulae, they can easily upset the array and not know what's happened.

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.