Vlookup to return multiple matches or return all matched lookup values - Method 1

In this video we will see how to build formula to return multiple match values in Excel ?

This video will teach you how to used array Indirect function to return multiple matched values.
This method is all about building dynamic range using Indirect function.

Click below link to learn about Indirect function.


Example used
How to get all names of a date of birth from student table?
Result will be out putted horizontally or column wise.

Click below link to download related file.
Excel file

Word file


*****Video Content Flow*****
-First we will apply formula then we will deconstruct it or will see its
working.
-We will use mainly Indirect and Small function for this.
-1st Let us find out a DOB for which many Names are present in
table using conditional formatting . Duplicate DOBs got highlighted
-We will use Array formula instead of normal one for this.
-I will show or demonstrate you using backward (top to bottom) approach for solving problem.

========================================
-Click below link to subscribe channel and stay tuned with latest uploads.

-Channel link

If liked this video then please subscribe,like and don't forget to click bell icon.
Make comment about your views, any suggestion or video topic you like to see.
======================================

You can watch learn from below videos also.
-Indirect function (dynamic ranging ) in excel.

-Change line or Paragraph or Simulate Line break using Concatenate and Char function.


-HOW TO GIVE OR CHANGE MACRO/VBA SHORTCUT KEY [HD]

-Auto update pivot data source without VBA

-Excel PIVOT TRICK - Auto generate sheets for each filter pages.

lookup all values,multiple value lookup in excel,excel vlookup,indirect function use,how use indirect function for multiple value lookup,get all matched values of lookup,