Match Index Array with Two Column Lookup | Advance Excel | VeerTutorial
We will use Match, Index and Array function with two column lookups. In this example our task is to find out sale amount based on two columns. Normally we use vlookup function when we have single lookup value but how to lookup values when we need to check or evaluate two columns. In this video we will learn how to search value based on two cells values.
#veertutorial #indexmatch #advanceexcel
English Video Playlist 👉👉👉👉👉
________________________________________________
Google Sheets Video 👉 https://bit.ly/2VofxfC
Excel 👉
Excel Pivot Table 👉
---------------------------------------------------------------------------
Hindi Video Playlist
________________________________________________
Excel 👉 http://tiny.cc/mnypaz
Tally ERP9 👉 http://tiny.cc/951paz
MS Access 👉 http://tiny.cc/j91paz
HTML5 & CSS3 👉 http://tiny.cc/w81paz
GST 👉 http://tiny.cc/ba2paz
---------------------------------------------------------------------------
Facebook ► / exceltips101
Twitter ► / veer_tutorial
Visit ►www.veertutorial.com
**********************************************
