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

Copper Contributor

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)

0 Replies