Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-842036%22%20slang%3D%22en-US%22%3ESingle%20cell%20concatenate%20result%20comparison%20with%20array%20on%20another%20worksheet%20shows%20N%2FA%20with%20INDEX%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842036%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20attatched%20file%20below.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20building%20a%20task%20list%20%2F%20calendar%20to%20combine%20multiple%20class%20work%20schedules%20alongside%20other%20projects%20of%20mine%20so%20that%20I%20can%20manage%20my%20time%20better.%20I%20cannot%20get%20the%20week%20view%20date%20at%20B14%20(which%20is%20concatenated%20to%20adapt%20to%20changes%20from%20dropdowns%20months%2C%20years%20and%20days)%20to%20successfully%20compare%20with%20the%20dates%20that%20I%20have%20in%20my%20task%20list%20(custom%20modified%20to%20display%20dates%20as%20full%20month%20name%20and%20number%20day%20without%20leading%200)%20inside%20of%20an%20index%20that%20will%20be%20returning%20a%20sucessfull%20comparison's%20neighboring%20description%20cell.%20Any%20help%20you%20provide%20would%20be%20greatly%20appreciated!%20If%20you%20have%20a%20template%20that%20already%20does%20what%20I%20am%20trying%20to%20do%20here%20that%20would%20be%20great%20but%20I%20am%20still%20trying%20to%20understand%20the%20codeing%20problem%20here.%20If%20you%20like%20the%20template%20I%20am%20building%20but%20have%20improvement%20suggestions%2C%20they%20would%20also%20be%20appreciated.%20Thank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F164265%22%20target%3D%22_blank%22%3E%40Office%20365%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-842036%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Bracken72
Regular Visitor

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies