Additional help needed with existing formula using LAMDA- Excel 365

It's not likely to be related to the other tabs/worksheets in your master workbook, as the formula is only referencing cells/ranges in the 'RESULTS' tab directly. The INDIRECT function is being used to reference tables in the workbook, but the syntax for this is the same as what was already working in your original sample workbook(s), so that wouldn't explain it.

I saw your comment on the previous thread, where you confirmed "The master workbook is named differently and contains more tabs than the redacted (included here) spreadsheet, but all of the table names and column headers are the same.", so there shouldn't be any issues when copying the formula over. However, I also noticed there was a bit of a struggle to get any of the suggested formulas on that thread to work, and a considerable amount of time was spent troubleshooting this. To transfer the formula from the sample workbook to your master workbook, highlight the entire formula from within the formula bar in the sample workbook and press Ctrl+C to copy, then select the destination cell in your master workbook, click into the formula bar (delete any previous formula, if applicable) and press Ctrl+V to paste.

#VALUE! errors can be difficult to track down, but it usually means there is an issue with one or more of the data types used. For example, =10+"text" will return this error because the addition operator is expecting two numbers (type 1) but received a text string (type 2). =TAKE(A1:A5,{3}) will also error because the rows argument is expecting a scalar (type 1) but received an array (type 64). I've reviewed my formula and don't see anything out of place. Even if there was, it wouldn't explain why the formula works in the sample workbook but not in the master workbook.

Having said that, I'm not really a fan of how the current "working" formula outputs the report. There's a different number of columns being selected from each table, and the field order is different between tables. The end result is a bit of a mess, where only the first 3 columns are identical across all 8 tables, and the rest are a mix-match of data types. This makes formatting dates virtually impossible, as fields like "Date Processed" and "Date Reconsidered" are appearing in the same columns as numeric fields like "PID" and "Issue Number".

Another option is to use something of a field-mapping table to link compatible fields and output them to the same column. For example:

=LET(
   _rep, RESULTS!$A$2,
   _beg, RESULTS!$B$2,
   _end, RESULTS!$C$2,
   _lst, RESULTS!$A$5:$A$12,
   _inc, (RESULTS!$E$5:$E$12="EXCEED")+(RESULTS!$E$5:$E$12="NOT MET"),
   IF(
      NOT(OR(_inc)),
      "[no records found]",
      LET(
         VALλ, LAMBDA(lbl,tId,csv,LAMBDA(x,CHOOSE(x,lbl,tId,csv))),
         EXPλ, LAMBDA(array,[rws],EXPAND(array,rws,9,"")),
         INCλ, LAMBDA(field3,field2,(field3=_rep)*(field2>=_beg)*(field2<=_end)),
         _fId, SEQUENCE(,9),
         _cId, VSTACK("1,2,3,4,,,5,13,14", "1,2,3,4,,5,6,10,11", "1,2,3,4,,,5,11,12", "1,2,3,4,5,,,7,8",
               "1,2,3,4,,,5,11,12", "1,2,3,5,7,6,4,12,13", "1,2,3,4,5,,6,14,15", "1,2,3,4,5,6,7,13,18"),
         REDUCE(
            EXPλ("Field"&_fId,2),
            FILTER(MAP(_lst,SEQUENCE(ROWS(_lst)),_cId,VALλ),_inc),
            LAMBDA(acc,val,
               LET(
                  tbl, INDIRECT("tbl"&SUBSTITUTE(SUBSTITUTE(val(1)," ",),"-",)&"[#ALL]"),
                  arr, SORTBY(EXPλ(CHOOSECOLS(tbl,--TEXTSPLIT(val(3),",",,1))),SORTBY(_fId,TEXTSPLIT(val(3),",")="")),
                  bdy, DROP(arr,1),
                  qry, FILTER(bdy,INCλ(CHOOSECOLS(bdy,3),CHOOSECOLS(bdy,2))),
                  VSTACK(acc,EXPλ("["&val(2)&"] "&val(1)&":"),EXPλ(TAKE(arr,1)),EXPλ(IF(ISBLANK(qry),"",qry),ROWS(qry)+1))
               )
            )
         )
      )
   )
)

The width of the output array in this example is fixed (9 columns). _cId is where the field-mapping is set for each table, and arr is where the field-mapping is applied (using SORTBY-TEXTSPLIT). This will output numeric fields like "PID" and "Issue Number" in Field5, and all date fields in Field7, making them easier to format:

Furthermore, if you're always dealing with the same 8 tables, it's also possible to eliminate the INDIRECT function by utilizing a custom CHOOSE based lambda function to select each table as needed. For example:

=LET(
   _rep, RESULTS!$A$2,
   _beg, RESULTS!$B$2,
   _end, RESULTS!$C$2,
   _lst, RESULTS!$A$5:$A$12,
   _inc, (RESULTS!$E$5:$E$12="EXCEED")+(RESULTS!$E$5:$E$12="NOT MET"),
   IF(
      NOT(OR(_inc)),
      "[no records found]",
      LET(
         VALλ, LAMBDA(lbl,tId,csv,LAMBDA(x,CHOOSE(x,lbl,tId,csv))),
         EXPλ, LAMBDA(array,[rws],EXPAND(array,rws,9,"")),
         INCλ, LAMBDA(field3,field2,(field3=_rep)*(field2>=_beg)*(field2<=_end)),
         TBLλ, LAMBDA(table_id,CHOOSE(table_id,
               tblClaims[#All],tblMiscAssignments[#All],tblProcessProtest[#All],tblIDD[#All],
               tblProcessAppeal[#All],tblDPU[#All],tblVetRRVDVOP[#All],tblRESEA[#All])),
         _fId, SEQUENCE(,9),
         _cId, VSTACK("1,2,3,4,,,5,13,14", "1,2,3,4,,5,6,10,11", "1,2,3,4,,,5,11,12", "1,2,3,4,5,,,7,8",
               "1,2,3,4,,,5,11,12", "1,2,3,5,7,6,4,12,13", "1,2,3,4,5,,6,14,15", "1,2,3,4,5,6,7,13,18"),
         REDUCE(
            EXPλ("Field"&_fId,2),
            FILTER(MAP(_lst,SEQUENCE(ROWS(_lst)),_cId,VALλ),_inc),
            LAMBDA(acc,val,
               LET(
                  tbl, TBLλ(val(2)),
                  arr, SORTBY(EXPλ(CHOOSECOLS(tbl,--TEXTSPLIT(val(3),",",,1))),SORTBY(_fId,TEXTSPLIT(val(3),",")="")),
                  bdy, DROP(arr,1),
                  qry, FILTER(bdy,INCλ(CHOOSECOLS(bdy,3),CHOOSECOLS(bdy,2))),
                  VSTACK(acc,EXPλ("["&val(2)&"] "&val(1)&":"),EXPλ(TAKE(arr,1)),EXPλ(IF(ISBLANK(qry),"",qry),ROWS(qry)+1))
               )
            )
         )
      )
   )
)

TBLλ is the lambda function that contains the references to each table, and TBLλ(val(2)) is where each table is recalled (replacing the INDIRECT function). I've also used a custom VALλ function here to make referencing the variables easier (replacing the INDEX function).

Please note, many of the variables and functions used in these examples can be defined in Name Manager, which would make the end formula shorter and easier to write. However, I refrained from doing so to make it as easy as possible for you to transfer the formula to your master workbook. If you're still experiencing issues and want to send me a copy of your master workbook in a private message (go to my profile page and click "Message"), I'll be happy to troubleshoot it for you. Cheers!

It didn't work. Just returns #VALUE! in the cell. Sorry, but I'm not familiar with what you are using. I can't really point to anything in the formula. Thanks for the try. :)

That did the trick for displaying the correct categories. However, each category that does not appear is still producing a certain number of blank lines between and, oddly, after the records for the displayed categories, there are 3 lines with !Value# errors in them. Not sure what that's about, but is there a way to fix so that only one blank line appears between the categories to separate them?