Vlookup (or similar) for partial text search and multiple conditions and OR condition

[davids4500]

I have a excel spreadsheet and i need to lookup all itemcodes on worksheet "ChreosdataA", that have either "AFR" or "CCH" in column A:A, and have the words "Air Freshener" in column C. And display them in the worksheet "Corestock" in column A with no blank rows between them. Also the words are only partial matches as all codes are unique except for the prefix. I hope you can help please. David

 

[alansidman]

Power Query solution

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Filtered Rows" = Table.SelectRows(Source, each Text.StartsWith([ITEMCODE], "AFR") or Text.StartsWith([ITEMCODE], "CCH")),
    #"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each Text.Contains([NAME], "Air Freshener"))
in
    #"Filtered Rows1"

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Vlookup (or similar)for partial text search and multiple conditions and OR condition
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[davids4500]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Vlookup (or similar)for partial text search and multiple conditions and OR condition
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Understood...No... no other places!

 

[davids4500]

crosspost Excel Formulas and functions Vlookup for partial search and multiple conditions and OR condition

David