Vlookup not working when range is extended.

[ExcellingAZ]

Not sure if im missing something in my formula or if excel is not functioning as it should. How its set-up if data in columns M - R match anything in columns C-H then column "S" will post as "TRUE" and condition formatting turns the cell BLACK. If there is no match, then Column "S" will show a FALSE value and cell will turn GREEN. As seen in the first screenshot. Now when I try to extend the lookup range from H60 to something bigger like H1560 it returns no matches. Are there limits on lookup ranges? Does my formula need adjusted or is my excel broke ..LOL

 

[Fluff]

Textjoin can handle a max string length of approx 32,700 characters, you are exceeding that by quite a long way.

Also is your profile up to date, as 2016 doesn't have textjoin