Home

Assistance with formula to return exact text if strings/dates match

%3CLINGO-SUB%20id%3D%22lingo-sub-858224%22%20slang%3D%22en-US%22%3EAssistance%20with%20formula%20to%20return%20exact%20text%20if%20strings%2Fdates%20match%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-858224%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20with%20a%20formula%20to%20return%20exact%20text%20if%20text%20is%20not%20known%20for%20a%20large%20array.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20formula%20returns%20nothing.%3C%2FP%3E%3CP%3E%3DIF(G2%3DCalendar!MonthToDisplay%2CT(Calendar!B6%3AH17)%2CFALSE)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-858224%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Siya_Mab
Occasional Visitor

Hi all,

 

Please help with a formula to return exact text if text is not known for a large array.

 

This formula returns nothing.

=IF(G2=Calendar!MonthToDisplay,T(Calendar!B6:H17),FALSE)

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies