3 Way Lookup Formula & Conditional Formatting, Date Criteria Mismatch & Merged Cell Trouble
See how to:
Create formula to lookup a value from a table with three criteria: INDEX and MATCH and MONTH functions. MONTH and Text Month Name Joined (Ampersand) to the number 1 to get a month value and match a serial number date with month Number Format to match against a text month.
Conditional formatting formula to highlight the intersection based on three criteria: one row header and two criteria as column headers. AND, DATE, MONTH and LOOKUP functions.