Link to home
Start Free TrialLog in
Avatar of Euro5
Euro5Flag for United States of America

asked on

find multiple conditions on different sheet

I want to return a value if multiple conditions on a row are met.
When all conditions match on same row - the same date, region, etc.
It has to look up a whole list on a separate sheet and find the one line that has all these matches and return the 'code'.
If no line matches, return a blank.
Test.xlsx
Avatar of Flyster
Flyster
Flag of United States of America image

You can try this Sumproduct formula:

=SUMPRODUCT(--(Sheet2!$A$2:$A$6=A2),--(Sheet2!$B$2:$B$6=B2),--(Sheet2!$C$2:$C$6=C2),Sheet2!$D$2:$D$6)

Open in new window

See attached.


PaulTest013020.xlsx

ASKER CERTIFIED SOLUTION
Avatar of Norie
Norie

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Euro5

ASKER

Thank you  - this is quite valuable and was very quick!!