Single cell concatenate result comparison with array on another worksheet shows N/A with INDEX

Copper Contributor

Hello, attatched file below. 

 

I am building a task list / calendar to combine multiple class work schedules alongside other projects of mine so that I can manage my time better. I cannot get the week view date at B14 (which is concatenated to adapt to changes from dropdowns months, years and days) to successfully compare with the dates that I have in my task list (custom modified to display dates as full month name and number day without leading 0) inside of an index that will be returning a sucessfull comparison's neighboring description cell. Any help you provide would be greatly appreciated! If you have a template that already does what I am trying to do here that would be great but I am still trying to understand the codeing problem here. If you like the template I am building but have improvement suggestions, they would also be appreciated. Thank you!

 

@Office 365

0 Replies