#shorts | INDEX MATCH Function in Excel | Revere Lookup in Excel

preview_player
Показать описание
#shorts
#excel
#index
#indexmatch
#match

If you want to do a reverse lookup in excel 2019 or in an older version of excel, you can use INDEX with the MATCH function to perform this activity.
Рекомендации по теме
Комментарии
Автор

Xlookup also very helpful for this example

tanishdogra
Автор

whenever I need it, simply watch your short, really helpful

royalrajasthani
Автор

We can also use choose option along with V look up to do reverse look up... Hence we should present index match as dynamic tool and not only as reverse v look up alternatives

ARUN
Автор

this kind of example are hard to see by others, thanks for such a wonderful example. Please give us more example with formula also .

saklecha
Автор

Your short is good but you should have shown about the freezing the range

Kf-Edits-sb
Автор

Bro pls mention about cell lock F4. Who are Fresher they won't be able to understand

atanughatak
Автор

Thanks 🙏🙏 very useful for me .... God bless you

subhodsawant
Автор

Helpful information👍
But Can we use Dget function instead of index+match function?

shyamlambe
Автор

We can use reverse Vlookup instead of index+match, btw nice video..

souvikdas
Автор

Thank you sir km time mai amazing experience
Can we do the same with vlook with a match to get all the data.

The_Accountern
Автор

Good, Very Helpful and easily explained👍

swapnilbhayade
Автор

Thanks Bhai apki vajah se mere 2 hour Bach Gaye, , apko suscribe kar liya he.. ese hi video banate raho.. 👍

Mayself
Автор

Thank you very much, Really Really it is helpful for me as well as others also, once again Thank you for knowledge sharing.

umakumarsarana
Автор

कम से कम वक्त में फॉर्मुला सिखाने के लिए 🙏
धन्यवाद धन्यवाद धन्यवाद

prakashrewale
Автор

Sir Xlookup bhi use kar sakte hai isme right?

saranggangurde
Автор

My first row was taking the correct way but the down row was not taking

debrajkar
Автор

Thank you so much! gain a subscriber for life.

priyanknbcc
Автор

If there is no unique lookup, how we can use. For example we are looking for 123456 but in data we have 0123456 here we have zero extra. Please help me how to find in these situations

Propertykingyou
Автор

Is this possible to search for required sheet name when there are large number of sheets in a workbook if possible please make a video on that through your channel

Kiransoffice
Автор

Vlookup bhi use kar sakte hain, but this is really quick

HimanshuSingh-khlg