Search cell for words in table and then return table header

Dave. That's amazing. I wish I fully understood it.

The Payees list will change number of rows over time. On my actual workbook it's already at 200.

I think I'll need some help with that additional calculation you mentioned.

What's the best way to count longest column in the array and return {1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,..... to the length of the count?

Thanks for everything so far.