MATCH MULTIPLE CRITERIA ACROSS MULTI-COLUMN RANGES RETURN VALUE FROM ANOTHER COLUMN
I am trying to look up an Employee from one column on one sheet and match it from a range on another sheet. Once matched, need to look up another specified criteria on another range which looks at the same column # in an identical column count range. Finally, look up another specified criteria at the same column # in an identical column count range and if all match, return the value from the same column # in another range with an identical column count. See attached file and picture diagram.
Help Article Resources
Check out the Formula Handbook template!