About this tutorial:
Video duration: 10:33
Download Excel File:
Full Title: Excel Magic Trick 1086: 3 Way Lookup Formula & Conditional Formatting, Date Criteria Mismatch & Merged Cell Trouble
See how to:
1. (00:11 min) 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.
2. (05:24 min) Conditional formatting formula to highlight the intersection based on three…