How can I write a Formula to change the Table Name in a Structured Reference? EXAMPLE: =COUNTIFS (BegBal[Referral], "*"&"Yes") Want to update the Table Name "BegBal" to "JanBal" as I drag the formula from right to left based on a Date Value in another cell. Need to nest the Formula in the COUNTIFS formula.
Have learned how to do it using INDIRECT: =COUNTIFS(INDIRECT(F$11&"[Referral]"), "*"&"Yes"). But then the [Table Header] is not Dynamic and Excel does not auto-populate. The header names my change. I'd prefer to use Index+Match or some variant.
Attachment included.
Bookmarks