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
You can try this Sumproduct formula:
Open in new window