|
Featured Tutorial
Featured Macro
Excel Magic Trick #117: Reverse 2-Way Lookup Part 1
Really Hard formula!!! See the functions, IF, INDEX, MATCH, SMALL, ROW, ROWS, COLUMN and COLUMNS all in one array formula.
See how to do a Reverse 2-Way Lookup with a complex Array formula.
See how to populate a list of names for patients with schedule book entries using this complex Array formula.
See how to do a Reverse 2-Way Lookup with a complex Array formula.
See how to populate a list of names for patients with schedule book entries using this complex Array formula.