Bottom Line: Learn several shortcuts to save time when writing lookup formulas. Skill Level: Beginner Watch the Tutorial Download the Excel Files I've included both the Begin and Final files so you can follow along and try the shortcuts for yourself. Five Shortcuts for Lookups Below are some shortcuts that will help you to write […]

Link to post: Shortcuts for Writing XLOOKUP and VLOOKUP Formulas