किसीभी बड़े से बड़े डाटा को कैसे सर्च किया जाताहै(Vlookup + ROW) और (INDEX+MATCH+MATCH)फार्मूला के साथ

It is a very difficult task to search a large amount of data and to find out different values by looking up one particular value while using Excel. You may encounter difficulties searching for very big data and in this video I am going to provide you a solution for this by using excel powerful formulas.

Hello all excel lovers, Welcome to my channel @digital walkway.
In this 11 minute Excel related video I am going to teach you how you can search very large data by using the VLOOKUP formula. Also I will teach you how you can do the same thing by using index plus Match plus Match formula. Here I am going to use a combination of VLOOKUP formula and what is that combination for that I am requesting you to watch this video till the end.

Outcome of this video as per below….!
1) How to search the large data by using VLOOKUP+ROW formula combination
2) How to search the large data by using index + match + match formula
3) How to create a dropdown list by using the Indirect formula

So now enjoy excel learning through our @digital walkway channel.

If you really like the content of our channel then please do like, share and subscribe to this channel. If you're new here, hit the subscribe button so you make sure to never miss upcoming excel related videos.

Start watching this video and I will catch you there goodbye have a nice day.

If you want to jump onto the specific part of this video then use below time stamp//---

0:00 Intro, what has done
1:57 How to make search window for large data with VLOOKUP + ROW
3:09 How to make dropdown list with INDIRECT formula
4:45 How transpose column heading from horizontal to vertical
5:37 How to use VLOOKUP + ROW to lookup values from large data set
9:20 How to use INDEX + MATCH + MATCH to lookup values from large data set

Your Search //----
vlookup with multiple criteria
vlookup formula in excel
vlookup from another sheet
vlookup formula
vlookup in excel
vlookup + countif
vlookup in hindi
vlookup interview questions and answers
vlookup in excel tagalog
vlookup in two different sheets
vlookup in excel شرح
vlookup in google sheets
vlookup in excel in tamil
vlookup in excel multiple sheets
vlookup in excel in hindi
vlookup in excel between two sheets
how to apply vlookup on large data

Keywords//---
index with trick
index with match
index with xmatch
index column
index match formula
excel index match formula
excel index match + match

#excel #digitalwalkway #exceltutorial

Видео किसीभी बड़े से बड़े डाटा को कैसे सर्च किया जाताहै(Vlookup + ROW) और (INDEX+MATCH+MATCH)फार्मूला के साथ канала DigitaL WalkwaY