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
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
Microsoft ExcelMicrosoft Office
Last Comment
Euro5
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you - this is quite valuable and was very quick!!
You can try this Sumproduct formula:
Open in new window
See attached.
PaulTest013020.xlsx