Excel Magic Trick 1086


3 Way Lookup Formula & Conditional Formatting, Date Criteria Mismatch & Merged Cell Trouble
See how to:
 (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.
(05:24 min)
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.


Download “Excel Magic Trick 1082 - 1100” Excel-Magic-Trick-1082-1100.zip – Downloaded 138 times – 2 MB

Be the first to comment

Leave a Reply