Excel Formula Help

If you want specific columns (e.g., Name, Job Code, Module)

Use CHOOSE inside FILTER:

MRD ABC123 tab

=FILTER(CHOOSE({1,2,3},DATA!B:B,DATA!F:F,DATA!I:I),(DATA!G:G="MRD")*(DATA!F:F="ABC123"),"No matching data")

SLRD ABC123 tab

=FILTER(CHOOSE({1,2,3},DATA!B:B,DATA!F:F,DATA!J:J),(DATA!G:G="SLRD")*(DATA!F:F="ABC123"),"No matching data")

SBRD ABC123 tab

=FILTER(CHOOSE({1,2,3},DATA!B:B,DATA!F:F,DATA!K:K),(DATA!G:G="SBRD")*(DATA!F:F="ABC123"),"No matching data")

ORD ABC123 tab

=FILTER(CHOOSE({1,2,3},DATA!B:B,DATA!F:F,DATA!L:L),(DATA!G:G="ORD")*(DATA!F:F="ABC123"),"No matching data")

MPRD ABC123 tab

=FILTER(CHOOSE({1,2,3},DATA!B:B,DATA!F:F,DATA!M:M),(DATA!G:G="MPRD")*(DATA!F:F="ABC123"),"No matching data")

FP XYZ123 tab (example with different job code)

=FILTER(CHOOSE({1,2,3},DATA!B:B,DATA!F:F,DATA!N:N),(DATA!G:G="FP")*(DATA!F:F="XYZ123"),"No matching data")

• Replace {1,2,3} with {1,2,3,4,5,...} and add more columns (e.g., DATA!C:C, DATA!D:D, etc.) if you need additional fields to appear in the tab.
• Just paste each formula into row 2 of the corresponding tab under your headers, and the results will spill down automatically.

This way, each district tab always pulls all rows that match both criteria and lines them up properly, instead of showing just the first match.

I'm currently working on Excel 2016, so please understand that I can't create a file or test the formulas.

But I still hope it helps you