IF Formula - For combining a combination of criteria
I'm hoping I can get some help with using an IF formula to combine a criteria.
The following three line item formulas are working correctly:
Then I have the following two line items that show what list items should be ignored.
Where I am having trouble is where I try to combine the two criteria in blue above and then still pull the data.
Here is the data:
If the data is a combination of Year 2018 and Company AU 100-517, then it should be ignored otherwise everything else should be included.
Column F and G - Should be pulling data only for 2018-100-500; 2019-100-500; 2019-100-517. But currently it is only pulling data for 2019-100-517. How can I update the formula to pick up the other two criterias?
Thanks for the community's help in advance.