Forum Discussion
Excel Formulas and functions Vlookup for partial search and multiple conditions and OR condition
Thanks! The formula should be entered in a single cell, and there should be enough empty cells below it for the result.
See the attached version.
HI
I need to remove the crossed out section, what modification to the formula do i need to make?
=FILTER(ChreosdataA!A2:A1000, (ISNUMBER(SEARCH("AFR", ChreosdataA!A2:A1000))+ISNUMBER(SEARCH("CCH", ChreosdataA!A2:A1000)))*ISNUMBER(SEARCH("Air Freshener", ChreosdataA!C2:C1000)), "")
Thank you david
This should do it:
=FILTER(ChreosdataA!A2:A1000, ISNUMBER(SEARCH("AFR", ChreosdataA!A2:A1000))*ISNUMBER(SEARCH("Air Freshener", ChreosdataA!C2:C1000)), "")
Dear Hans Much appreciated and yes it is successful.
Just to change it to another scenerio I have a creditor names in column C43:C72, I have dates in column E43:E72 and I have $ values in Column G43:G72.
The formula is =SUMPRODUCT($G$43:$G$72,--(MONTH($E$43:$E$72)=9))
and I need to add if column C43:C72 = "Creditor". How do I do that. Much appreciated
David
davids4500 Add the condition to the second part. As a consequence, you won't need the -- anymore:
=SUMPRODUCT($G$43:$G$72, (MONTH($E$43:$E$72)=9)*($E$43:$E$72="Creditor"))
- Very good and very much appreciated...Thank you for having the knowledge and happy to share it...
David