Forum Discussion
Excel Formula Help
Hi NikolinoDE, so i thought this was going to work but when i enter it into the other cells its only pulling the first data that matches that criteria. Any other thoughts or ideas?
NikolinoDE *See Sheet Attached* this is what it looks like on my sheet
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.
I'm currently working on Excel 2016, so please understand that I can't create a file or test the formulas.
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.
But I still hope it helps you🙂
I understand, im still getting a spill error and selecting the columns i want. I really appreciate your time and help with this. Not sure why it isnt working tho
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
