Forum Discussion
Solved
Excel Formulas and functions Vlookup for partial search and multiple conditions and OR condition
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 th...
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.Thank you for the formula. However, i receive a #SPILL as a return
I have attached part of the spreadsheet that I am using with the relevant columns.
Thanking you
David
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.
HansVogelaar Well this is so good. Worked perfectly and just what I needed.
Much appreciated and thank you for taking time.
David