Amend FILTER function to include data from other columns

Hi all,

I have a filter function from a workbook which works fine - but needs a small tweak, can anyone guide me please?

Currently:

=FILTER('Tracker.xlsx]Tickets'!$A$2:$A$4981,IFERROR('[Tracker.xlsx]Tickets'!$E$2:$E$4981="MFP",0))

I want to change the filter to add in a condition to include data from the 'Tracker' workbook, 'Tickets' tab, column H which has any of the values: Segment 0, Segment B, Segment C, Segment D

How do I update my filter formula to reflect this?

Thank you

My guess it would be something like the formula below which utilizes the "+" for the multiple criteria in a filter. + is equal to OR statement and a * is equal to an AND statement just as an FYI. I couldnt test this formula because you didnt include a workbook so it is freehand.

Formula:

Please Login or Register  to view this content.

Thank you dosydos for giving this a go, I've attached a sample workbook (represents the source workbook) and noted on it what I need to achieve on a different workbook with the filter function

Thank you

HI Fluff13 thank you - not got getting any success with your formula for some reason unfortunately
it's not returning any results but i`ll keep trying

Hi Fluff13 I did change the file name - fopr some reason my two word file name: ticket racker is turning into ticketracker (one word) when applying the formula and I`m getting #VALUE errors!

Try this and see...

The stuff in the mini-table can, of course, be hard coded into the formula, too.

Hi Glenn

Thank you - can I ask how i can add in more columns to be returned on "The Other sheet"?... Think it's a potential solution so far.. thank you!

Your Q is too general. What do you want to include/exclude? On a modified formula and sheet:

Formula:

Please Login or Register  to view this content.

The bit in GREEN includes only those that meet the (single) criterion.
The bit in RED EXCLUDES the MULTIPLE values in J1:J3
The bit in BLUE includes ONLY the MULTIPLE values in K1:K4
The bit in cyan means you only have to set the range in ONE place. All the INDEX(d,,3) bits select the correct columns.