## A Few Questions About VLOOKUP & INDEX MATCH

A Few Questions About VLOOKUP & INDEX MATCH As I mentioned in the newsletter, my long awaited Ultimate Lookup Formulas Course is coming soon. This is an online video course that will help you learn how to write a variety of lookup formulas in Excel. The course covers a lot of different functions like VLOOKUP, […]

## How to Use MATCH Function | Microsoft Excel

How to Use MATCH Function | Microsoft Excel MATCH function is a lesser known function. Match function will return a position of the specific value given by you from a row and a column. Syntax of MATCH Function =MATCH(lookup_value,lookup_array,[match_type]) Arguments For MATCH Function lookup_value: it is a value which you want to match in lookup_array lookup_array: it […]

## VLOOKUP CHOOSE vs INDEX MATCH Performance Test

VLOOKUP CHOOSE vs INDEX MATCH Performance Test Bottom Line: Which is faster? Let’s compare the speeds of two popular formulas that are used to look to the left. Skill Level: Advanced ﻿ Download the Excel File You can follow along and test for yourself using the same worksheet I use in the video. VLOOKUP CHOOSE […]

## How to Use Index Match Instead of Vlookup

How to Use Index Match Instead of Vlookup Bottom Line: Learn how to use the INDEX and MATCH functions as an alternative to VLOOKUP. Skill Level: Beginner ﻿ Download the Excel File Here is the Excel file that I used in the video. I encourage you to follow along and practice writing the formulas. INDEX […]