Filter Function with Lookup or second condition

%3CLINGO-SUB%20id%3D%22lingo-sub-3196110%22%20slang%3D%22en-US%22%3EFilter%20Function%20with%20Lookup%20or%20second%20condition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3196110%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20looking%20to%20minimise%20the%20number%20of%20columns%20required%20for%20a%20filter%20function%20formula%20whereby%20a%20table%20is%20filtered%20by%202%20conditions%2C%20one%20is%20date%2C%20the%20second%20is%20Account%20Type.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20get%20it%20to%20work%20if%20the%20table%20(Table1)%20contains%20an%20Account%20Type%20Column%2C%20however%2C%20interested%20to%20know%20if%20this%20lookup%20can%20be%20contained%20within%20the%20Filter%20Function.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBased%20on%20the%20way%20the%20extended%20spreadsheet%20works%2C%20I%20would%20reduce%20the%20number%20of%20columns%20by%2024.%3C%2FP%3E%3CP%3EWhilst%20this%20isn't%20a%20big%20issue%20as%20I%20can%20hide%20them%2C%20I%20am%20interested%20in%20finding%20out%20how%20far%20the%20Filter%20Function%20can%20go.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%20attached%3A%3C%2FP%3E%3CP%3EQ%20-%20What%20is%20the%20Filter%20function%20required%20to%20cell%20H10%20if%20Table%201%20does%20not%20have%20an%20Account%20Type%20Column%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20aim%20is%20to%20filter%20Table1%20to%20show%20only%20data%20that%20is%20in%20the%20user%20selected%20fields%20(pink).%3C%2FP%3E%3CP%3ENormally%20Table1%20and%20Table2%20are%20on%20their%20own%20separate%20worksheets%20with%20just%20the%20spill%20table%20by%20itself.%20However%2C%20for%20the%20sake%20of%20clarity%2C%20I%20have%20combined%20onto%20the%20one%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20tips%20would%20be%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MS%20Excel%20FILTER%20Function%20-%20Nested%20or%20Multiple%20Conditions.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F350145iA9C0B85E442B021F%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22MS%20Excel%20FILTER%20Function%20-%20Nested%20or%20Multiple%20Conditions.png%22%20alt%3D%22MS%20Excel%20FILTER%20Function%20-%20Nested%20or%20Multiple%20Conditions.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20-%20I%20couldn't%20work%20out%20how%20to%20add%20the%20excel%20file...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3196110%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I am looking to minimise the number of columns required for a filter function formula whereby a table is filtered by 2 conditions, one is date, the second is Account Type.

 

I can get it to work if the table (Table1) contains an Account Type Column, however, interested to know if this lookup can be contained within the Filter Function.

 

Based on the way the extended spreadsheet works, I would reduce the number of columns by 24.

Whilst this isn't a big issue as I can hide them, I am interested in finding out how far the Filter Function can go.

 

 

Example attached:

Q - What is the Filter function required to cell H10 if Table 1 does not have an Account Type Column

 

The aim is to filter Table1 to show only data that is in the user selected fields (pink).

Normally Table1 and Table2 are on their own separate worksheets with just the spill table by itself. However, for the sake of clarity, I have combined onto the one sheet.

 

Any tips would be appreciated.

 

MS Excel FILTER Function - Nested or Multiple Conditions.png

 

Sorry - I couldn't work out how to add the excel file...

1 Reply
maybe this link is helpful, but I still can't figure i out...

https://techcommunity.microsoft.com/t5/excel/concatenating-arguments-in-the-filter-function/m-p/1426...

Does this help?
I was unable to find a combination that worked....