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