Formiraex Excel and Sheets Tutorial

interactive online courses

This is the learn by doing course that will help you to gain the skills in an interactive way.

Beginner to Pro in Excel

Helpful guides primarily delivered in the interactive course. For example, you'll learn about Sumif, Countif, Vlookup, Match, Index, and much more. That will help you to practice like a pro.

available on the appsource

Products supported Excel 2016+, Excel 2016 for Mac , Excel Online

VLOOKUP, MATCH & INDEX

October 21, 2020admin

Install Add-ons: Formiraex You will learn about How to use the VLOOKUP, MATCH & INDEX functions. Use VLOOKUP to search and get the desired value from the range of data.example:=VLOOKUP(I3, D3:G6, 4, FALSE)* I3 is the lookup value.* D3:G6 is the Table array of data searched.* 4 is the column number of the returned data from Table array.* TRUE/FALSE is the logic.TRUE = Approximate matchFALSE