Excel Formula Help

Example: Pulling the Module column (Column I in DATA)

In the Module column of MRD ABC123 (let’s say column D):

=FILTER(DATA!I:I, (DATA!G:G="MRD")*(DATA!F:F="ABC123"), "No matching data")

Explanation:

• DATA!I:I → MRD Module column
• (DATA!G:G="MRD") → District matches MRD
• (DATA!F:F="ABC123") → Job Code matches ABC123
• "No matching data" → optional message if no match

Example: Pulling another column (e.g., Employee Name in Column B)

=FILTER(DATA!B:B, (DATA!G:G="MRD")*(DATA!F:F="ABC123"), "")

Step-by-step for all columns on MRD ABC123 tab

1. Decide which columns on your tab correspond to which columns on DATA.
2. In each column, use:

=FILTER(DATA!<COLUMN>, (DATA!G:G="MRD")*(DATA!F:F="ABC123"), "")

1. Replace <COLUMN> with the column from DATA you want to pull.

For other districts/tabs (SLRD, SBRD, etc.)

• Change the District and Module column:

SLRD SLR123 Module (Column J in DATA):

=FILTER(DATA!J:J, (DATA!G:G="SLRD")*(DATA!F:F="SLR123"), "")

SBRD SBR123 Module (Column K in DATA):

=FILTER(DATA!K:K, (DATA!G:G="SBRD")*(DATA!F:F="SBR123"), "")

Notes

• Each column uses its own FILTER formula.
• The rows will automatically spill to match all rows from DATA that meet both criteria.
• This works in Excel 365 / Excel 2021+.

My answers are voluntary and without guarantee!

Hope this will help you.