VLOOKUP Tutorials for Excel - Beginner to Advanced - Excel Vlookup Assistant - Watch A Preview Of How It Works!

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/ In this video, I share a preview of a new app called VLOOKUP Assistant, which makes it faster and easier to write lookup formulas like VLOOKUP and INDEX MATCH. Download the example Excel file: https://www.excelcampus.com/functions/vlookup-assistant-preview/ This tool is currently a set of VBA macros that will write lookup formulas for you. It has two main features: 1. Create Lookup Formulas When you run the macros you will just be prompted to select the cell that contains the lookup value, and a single row in the table array (lookup/return range). The macro will do all the work to create the actual formula and insert it in the active cell. It will also make the table array (lookup/return) ranges absolute, so you can quickly copy the formula down. VLOOKUP Assistant only requires you to select a single row in the table array, instead of having to select the entire range. This can be a time-consuming task if your data range has thousands of rows and you select it with the mouse. 2. Convert Lookup Formulas VLOOKUP Assistant will also convert existing VLOOKUP formulas to INDEX MATCH. You simply select a cell that contains a VLOOKUP formula and run a macro. The new INDEX MATCH formula will be displayed in a message box and copied to the clipboard. You can then paste it into the cell. This gives you the option to undo the formula. Related Videos: How to Create Your Personal Macro Workbook: https://youtu.be/rD2-mSbTuL0 How to Add Macro Buttons to the Ribbon: https://youtu.be/dmdolFcS-fI How to Add Macro Buttons to a Worksheet: https://youtu.be/bsXZKQCcd5g How to Create Keyboard Shortcuts to Run Macros: https://youtu.be/w_d6HzylJ3Q Copy or Import VBA Code Modules: https://youtu.be/ett0WiTfQuI VLOOKUP Tutorial for Excel - Everything You Need to Know: https://youtu.be/d3BYVQ6xIE4 #MsExcel #ExcelCampus 00:00 Introduction 00:27 VLOOKUP Assistant 01:40 The lookup value 03:52 Convert Lookup Formulas