Forum Discussion
Filter Detail
If I have 2 columns. In column 2, a value may repeat multiple times, ex. "1234" is found 5 or 6 times, doesn't matter. I want to know if column 1 has value "ABCD" and "EFGH" on the same rows as "1234...
Hi Mark,
Please try this formula and find it in the attached workbook:
=IF(AND(SUMPRODUCT(ISNUMBER(MATCH(E2:E3,IF(D2=B2:B9,A2:A9),0))+0)=COUNTA(E2:E3),COUNTA(E2:E3)<>0),"Yes","No")
The formula in the above screenshot is located in cell F2 and it gives you (No) as a result because the Producer A has no corresponding value called (Buses)!
But if you change the value of (Buses) in cell E3 to (Trucks), the formula will return (Yes).
Please note that the formula is an array formula so you have to press https://support.office.com/en-us/article/Guidelines-and-examples-of-array-formulas-7D94A64E-3FF3-4686-9372-ECFD5CAA57C7 to enter this formula each time you open it in the edit mode in order to get the correct result.
Hope that helps
Regards