SOLVED

Subset of data

%3CLINGO-SUB%20id%3D%22lingo-sub-3492954%22%20slang%3D%22en-US%22%3ERe%3A%20Subset%20of%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3492954%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1420185%22%20target%3D%22_blank%22%3E%40Ric_S_CLT%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DFILTER(A1%3AE6%3BC1%3AC6%3D%22Audit%22)%0A%3DFILTER(A1%3AE6%3BC1%3AC6%3D%22Self-Identified%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EYou%20can%20use%20the%20FILTER%20function.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22subsets.JPG%22%20style%3D%22width%3A%20782px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22subsets.JPG%22%20style%3D%22width%3A%20782px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22subsets.JPG%22%20style%3D%22width%3A%20782px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22subsets.JPG%22%20style%3D%22width%3A%20782px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22subsets.JPG%22%20style%3D%22width%3A%20782px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22subsets.JPG%22%20style%3D%22width%3A%20782px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22subsets.JPG%22%20style%3D%22width%3A%20782px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F379303i16C22994037ABDFA%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22subsets.JPG%22%20alt%3D%22subsets.JPG%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3492892%22%20slang%3D%22en-US%22%3ESubset%20of%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3492892%22%20slang%3D%22en-US%22%3E%3CP%3EI%20run%20a%20weekly%20report%2C%20using%20a%20filtered%20dump%20of%20data%20from%20a%20company%20database.%20The%20database%20is%20maintained%20by%20a%20utility%20department%20with%20a%20large%20user%20forum%3B%20in%20response%20to%20user%20forum%20requests%2C%20data%20fields%20are%20added%20frequently%20to%20the%20database%20%E2%80%93%20several%20times%20monthly%2C%20and%20can%20be%20inserted%20anywhere%20in%20the%20dataset.%20My%20report%20displays%20a%20static%20set%20of%20fields%3B%20the%20data%20in%20the%20fields%20changes%20often.%20I%20also%20need%20to%20be%20able%20to%20split%20the%20dataset%20up%20into%20several%20groups%20of%20data.%20The%20number%20of%20rows%20can%20vary%20week%20over%20week%2C%20as%20an%20item%20drops%20off%20%E2%80%93%20sometimes%20before%20its%20due%20date%2C%20so%20the%20due%20date%20is%20not%20a%20field%20that%20can%20be%20used%20to%20filter%20out.%20I%E2%80%99m%20looking%20for%20a%20formula(s)%20that%20would%20read%20the%20headers%2C%20extract%20only%20the%20fields%20that%20I%20need%2C%20and%20also%20extract%20the%20fields%20I%20need%20into%20several%20tabs%20based%20on%20one%20of%20the%20values.%20In%20the%20example%20below%2C%20the%20first%20table%20is%20a%20representation%20of%20the%20tab%20with%20this%20week%E2%80%99s%20full%20dataset%3B%20the%20second%20and%20third%20tables%20are%20the%20results%20I%E2%80%99m%20seeking%20to%20have%20extracted.%20Have%20a%20formula(s)%20that%20would%20accomplish%20this%3F%26nbsp%3BThank%20you.%20I%20had%20tried%20Filter%2C%20but%20Filter%20will%20return%20all%20the%20fields%20in%20the%20original%20dataset.%20How%20can%20I%20return%20only%20the%20fields%20I%20need%20(in%20the%20example%2C%20columns%20A%2C%20B%2C%20C%20and%20E%2C%20but%20exclude%20D%3F%20And%20keeping%20in%20mind%20that%20next%20week's%20data%20may%20have%20a%20new%20field%20inserted%20before%20Due%20Date%2C%20and%20I%20won't%20know%20that%20field's%20label%20or%20content%20until%20it%20appears).%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2230%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22102%22%3E%3CP%3EA%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22120%22%3E%3CP%3EB%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22126%22%3E%3CP%3EC%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3ED%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3EE%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2230%22%3E%3CP%3E1%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22102%22%3E%3CP%3E%3CSTRONG%3EIssue%20ID%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22120%22%3E%3CP%3E%3CSTRONG%3EIssue%20Title%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22126%22%3E%3CP%3E%3CSTRONG%3EIssue%20Source%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3E%3CSTRONG%3EIssue%20Owner%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3E%3CSTRONG%3EDue%20Date%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2230%22%3E%3CP%3E2%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22102%22%3E%3CP%3E123%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22120%22%3E%3CP%3EYadaYada%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22126%22%3E%3CP%3ESelf-Identified%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3EBob%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3E5%2F31%2F2022%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2230%22%3E%3CP%3E3%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22102%22%3E%3CP%3E456%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22120%22%3E%3CP%3EBadaBing%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22126%22%3E%3CP%3EAudit%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3EKaren%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3E12%2F31%2F2023%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2230%22%3E%3CP%3E4%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22102%22%3E%3CP%3E789%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22120%22%3E%3CP%3EYips%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22126%22%3E%3CP%3ESelf-Identified%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3ESam%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3E8%2F31%2F2022%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2230%22%3E%3CP%3E5%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22102%22%3E%3CP%3E1010%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22120%22%3E%3CP%3EZipZilch%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22126%22%3E%3CP%3EAudit%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3EFred%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3E7%2F15%2F2023%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2230%22%3E%3CP%3E6%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22102%22%3E%3CP%3E1212%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22120%22%3E%3CP%3EXRayGoggles%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22126%22%3E%3CP%3ERisk%20Review%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3EJeff%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3E9%2F15%2F2025%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2230%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22102%22%3E%3CP%3EA%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22120%22%3E%3CP%3EB%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22126%22%3E%3CP%3EC%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3ED%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2230%22%3E%3CP%3E1%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22102%22%3E%3CP%3E%3CSTRONG%3EIssue%20ID%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22120%22%3E%3CP%3E%3CSTRONG%3EIssue%20Title%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22126%22%3E%3CP%3E%3CSTRONG%3EIssue%20Source%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3E%3CSTRONG%3EDue%20Date%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2230%22%3E%3CP%3E2%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22102%22%3E%3CP%3E123%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22120%22%3E%3CP%3EYadaYada%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22126%22%3E%3CP%3ESelf-Identified%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3E5%2F31%2F2022%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2230%22%3E%3CP%3E4%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22102%22%3E%3CP%3E789%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22120%22%3E%3CP%3EYips%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22126%22%3E%3CP%3ESelf-Identified%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3E8%2F31%2F2022%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2230%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22102%22%3E%3CP%3EA%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22120%22%3E%3CP%3EB%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22126%22%3E%3CP%3EC%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3ED%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2230%22%3E%3CP%3E1%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22102%22%3E%3CP%3E%3CSTRONG%3EIssue%20ID%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22120%22%3E%3CP%3E%3CSTRONG%3EIssue%20Title%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22126%22%3E%3CP%3E%3CSTRONG%3EIssue%20Source%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3E%3CSTRONG%3EDue%20Date%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2230%22%3E%3CP%3E3%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22102%22%3E%3CP%3E456%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22120%22%3E%3CP%3EBadaBing%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22126%22%3E%3CP%3EAudit%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3E12%2F31%2F2023%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2230%22%3E%3CP%3E5%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22102%22%3E%3CP%3E1010%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22120%22%3E%3CP%3EZipZilch%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22126%22%3E%3CP%3EAudit%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E%3CP%3E7%2F15%2F2023%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3492892%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3494000%22%20slang%3D%22en-US%22%3ERe%3A%20Subset%20of%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3494000%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1420185%22%20target%3D%22_blank%22%3E%40Ric_S_CLT%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DLET(%20f%2C%20FILTER(Table1%2C%20Table1%5BIssue%20Source%5D%20%3D%20%24A%249)%2C%0A%20%20INDEX(%20f%2C%20SEQUENCE(%20ROWS(f)%20)%2C%20XMATCH(%20A10%3AD10%2C%20Table1%5B%23Headers%5D%20)%20)%20)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Efor%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20575px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20575px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20575px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20575px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F379362i431E0065C8BF248A%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3495010%22%20slang%3D%22en-US%22%3ERe%3A%20Subset%20of%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3495010%22%20slang%3D%22en-US%22%3ENice%2C%20thank%20you!%20That%20worked.%20Had%20to%20play%20with%20it%20for%20a%20bit%20-%20didn't%20seem%20to%20want%20to%20work%20when%20I%20started%20the%20new%20table%20in%20a%20different%20tab%2C%20but%20did%20work%20when%20I%20started%20the%20new%20table%20in%20the%20same%20tab%20and%20then%20cut-and-pasted%20into%20a%20new%20tab.%20Thanks%20again!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3495839%22%20slang%3D%22en-US%22%3ERe%3A%20Subset%20of%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3495839%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1420185%22%20target%3D%22_blank%22%3E%40Ric_S_CLT%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome.%20It%20shall%20work%20in%20different%20sheet%2C%20just%20play%20with%20references.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I run a weekly report, using a filtered dump of data from a company database. The database is maintained by a utility department with a large user forum; in response to user forum requests, data fields are added frequently to the database – several times monthly, and can be inserted anywhere in the dataset. My report displays a static set of fields; the data in the fields changes often. I also need to be able to split the dataset up into several groups of data. The number of rows can vary week over week, as an item drops off – sometimes before its due date, so the due date is not a field that can be used to filter out. I’m looking for a formula(s) that would read the headers, extract only the fields that I need, and also extract the fields I need into several tabs based on one of the values. In the example below, the first table is a representation of the tab with this week’s full dataset; the second and third tables are the results I’m seeking to have extracted. Have a formula(s) that would accomplish this? Thank you. I had tried Filter, but Filter will return all the fields in the original dataset. How can I return only the fields I need (in the example, columns A, B, C and E, but exclude D? And keeping in mind that next week's data may have a new field inserted before Due Date, and I won't know that field's label or content until it appears).



 

 

A

B

C

D

E

1

Issue ID

Issue Title

Issue Source

Issue Owner

Due Date

2

123

YadaYada

Self-Identified

Bob

5/31/2022

3

456

BadaBing

Audit

Karen

12/31/2023

4

789

Yips

Self-Identified

Sam

8/31/2022

5

1010

ZipZilch

Audit

Fred

7/15/2023

6

1212

XRayGoggles

Risk Review

Jeff

9/15/2025

 

 

 

A

B

C

D

1

Issue ID

Issue Title

Issue Source

Due Date

2

123

YadaYada

Self-Identified

5/31/2022

4

789

Yips

Self-Identified

8/31/2022

 

 

A

B

C

D

1

Issue ID

Issue Title

Issue Source

Due Date

3

456

BadaBing

Audit

12/31/2023

5

1010

ZipZilch

Audit

7/15/2023

 

3 Replies
best response confirmed by Ric_S_CLT (New Contributor)
Solution

@Ric_S_CLT 

That could be

=LET( f, FILTER(Table1, Table1[Issue Source] = $A$9),
  INDEX( f, SEQUENCE( ROWS(f) ), XMATCH( A10:D10, Table1[#Headers] ) ) )

for

image.png

Nice, thank you! That worked. Had to play with it for a bit - didn't seem to want to work when I started the new table in a different tab, but did work when I started the new table in the same tab and then cut-and-pasted into a new tab. Thanks again!

@Ric_S_CLT , you are welcome. It shall work in different sheet, just play with references.