#shorts

#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.

[@tanishdogra7432]

Xlookup also very helpful for this example

[@ExcelUniverse]

XLOOKUP is the most powerful function, but it's available in office 365 or in newer versions.

[@royal1rajasthani]

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

[@ExcelUniverse]

I'm glad to hear it, and it inspires me to create such useful content, thanks a lot.

[@2105ARUN]

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

[@ExcelUniverse]

You are right, but using CHOOSE with VLOOKUP is not a dynamic, well it's a one more alternate to do lookup from right to left.

[@saklecha60]

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

[@ExcelUniverse]

Thanks for your valuable feedback

[@Kf-Edits-s6b]

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

[@ExcelUniverse]

Thanks for your feedback, I must remeber next time.

[@souvikdas9110]

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

[@ExcelUniverse]

Yes, you are right

[@subhodsawant671]

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

[@ExcelUniverse]

Thanks for your feedback 😀

[@syedsalman9206]

Xlookup will be easy

[@ExcelUniverse]

Yes It's very easy to use, but available in Office 365 or Office 2021

[@Mayself160]

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

[@ExcelUniverse]

🙏

[@priyanknbcc4113]

Thank you so much! gain a subscriber for life.

[@ExcelUniverse]

Glad it helped!

[@santoshr1]

Thanks very useful information 🙏

[@ExcelUniverse]

Most welcome

[@swapnilbhayade7444]

Good, Very Helpful and easily explained👍

[@ExcelUniverse]

🙏

[@umakumarsarana6378]

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

[@ExcelUniverse]

It's my pleasure 🙏

[@atanughatak868]

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

[@ExcelUniverse]

Thanks for your suggestion 😊

[@aroundtheworld2367]

If f4 doesn't work..give function f4

[@hassanalianees5530]

Jaaduu. Briliant Brother

[@ExcelUniverse]

Really 🎩 🪄

[@twistttcreater487]

Thank you lots of love

[@ExcelUniverse]

🤔

[@subhodsawant671]

Thanks

[@ExcelUniverse]

Welcome

[@Shriradhekrishna001.]

Thx sir for this ❤ its so help full 😊

[@ExcelUniverse]

Most welcome 😊

[@sinister534]

2 ghante computer class mai waste ho gaya iss per kyuki waha per unko theek se teaching krrna nhi aata

[@ExcelUniverse]

Thanks for your feedback. Lakin aisi bat nahi hai, har aadmi ka apna alag najariya hai chijo ko samajhne or samjhane ka. Well thanks again.

[@prakashrewale9776]

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

[@ExcelUniverse]

😊

[@pramodcbe]

In this case, Xlookup might be more easier than this.

[@ExcelUniverse]

Yes you are right, but XLOOKUP available only in Excel 365 or Excel 2021.

[@debrajkar2518]

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

[@ExcelUniverse]

Please share your file where you applied formula. Whatsapp [phone]

[@mil450]

This is exactly what I need to learn but idk what you’re saying my man! It’s ok I’ll just watch it 50 times 😂

[@ExcelUniverse]

🤔

[@Harishsingh-xr7pi]

Jitna excel ko seekhna ki koshish krta hu utna confuse ho jata hu

[@ExcelUniverse]

Jitni Jarurat utna sikhiye fir confuse nahi honge. Well excel ke kuchh hi formule and functions hai jiski jyada jarurat hai.

[@The_Accountern]

​@@ExcelUniversewhat an amazing reply .

[@shyamlambe4411]

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

[@ExcelUniverse]

thanks for your feedback, DGET can return single record only, if you need to lookup data for multiple record you can use INDEX+MATCH, XLOOKUP, HLOOKUP.

[@shyamlambe4411]

@@ExcelUniverse Thanks

[@ExcelUniverse]

🙂

[@Lifebizandopinion]

THANK YOU SO MUCH

[@ExcelUniverse]

Most welcome 🙏

[@rakeshmlearningentertainme6099]

Amazing video

[@ExcelUniverse]

Thanks!

[@The_Accountern]

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

[@ExcelUniverse]

Thanks for your feedback. Well Vlookup can look data only from left to right, but index match can be used to lookup data in all direction

[@arjunsingh9852]

this is awesome

[@ExcelUniverse]

Thanks 🙏

[@fandafacts6688]

Thank u so much

[@ExcelUniverse]

Most welcome 😊

[@user-ym5em3py8d]

Thank u thank u so much sir

[@ExcelUniverse]

Most welcome

[@ManojSingh-jo9eq]

Very nice

[@ExcelUniverse]

Thanks

[@preetcomputertipsandtricks7232]

Thank you sir

[@ExcelUniverse]

Most welcome

[@rajeevpal2768]

Helpful.

[@ExcelUniverse]

Thanks Rajeev G

[@royaljunkies6056]

Awesome

[@ExcelUniverse]

👍

[@rakeshdas-dw5fd]

Did not work showing #N/A error please help

[@ExcelUniverse]

Share your file with formula you applied. WhatsApp @ 9708153000

[@Propertyking4you]

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

[@ExcelUniverse]

Let's say cell A1 has the number 0123456 and cell B1 has the corresponding text ABC now, if you want to get the result against 123456, use the formula =INDEX(B1,MATCH(123456,INDEX(--A1,0),0)) if you are using excel 365 you can use the formula =XLOOKUP(123456,--A1,B1)

[@saranggangurde4101]

Sir Xlookup bhi use kar sakte hai isme right?

[@ExcelUniverse]

Wo to sabse best option hai

[@bettlegroundsmobileindia6981]

WOW SUPERB

[@ExcelUniverse]

Thanks 🤗

[@shipradebnath9537]

Thankyou bro

[@ExcelUniverse]

😊

[@ishan89100]

How to show all matching values for a match in range

[@ExcelUniverse]

Use MATCH function to match the record

[@HimanshuSingh-kh1lg]

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

[@ExcelUniverse]

INDEX Match is much easier then VLOOKUP to do reverse lookup in older version of excel. Now we have XLOOKUP function to do the same

[@HimanshuSingh-kh1lg]

@@ExcelUniverse yes sir, Xlookup...I mistakenly typed Vlookup 😅

[@ExcelUniverse]

😃

[@vishaljagtap4330]

Trying the formula from few days but not succeeded. After watching this short able do it successfully. Thanks

[@ExcelUniverse]

It's my pleasure

[@rizkymaghfira9918]

thanks you👍🏻👍🏻👍🏻

[@ExcelUniverse]

Welcome 👍

[@bettlegroundsmobileindia6981]

Please make more videos

[@ExcelUniverse]

sure

[@jayhin2898]

jordar

[@ExcelUniverse]

✨️🙏

[@ajayrao5290]

I am getting only first name to all selected cell for example Evan Zigomala...

[@ExcelUniverse]

Can you please share file where you applied formula. Whatsapp [phone]

[@flickhunter8900]

But we can use x lookup right?

[@ExcelUniverse]

Yes But it's available only in Microsoft 365 and Microsoft 2021

[@DeltaTraderSorav]

idher xlookup function use kar sakte gai

[@ExcelUniverse]

Yes

[@AmitKumar-mf5dq]

Horizontal format mai bhi hum index match laga sakte hai

[@ExcelUniverse]

Yes, checkout the link below for more detail on INDEX MATCH kzbin.info/www/bejne/hYPRZJtqgNSBppY

[@windyfebbiayuni5581]

what if some values have special characters like ba'diyah cause it not recognizeable

[@ExcelUniverse]

can you please share a sample file where you get error. Because it's not showing any error at my end. WhatsApp @ 9708153000

[@kukkirules]

Xlookup .. much easier to use

[@ExcelUniverse]

Yes

[@sandippawar4070]

how to free row

[@ExcelUniverse]

You Can use dollar to fix Row, Column or entire cell Only Row Fixed (A$1) Only Column Fixed ($A1) Entire Cell Fixed ($A$1) If you want to free row, you can choose second, where row is free and column is fixed.

[@ruthlessemperor6730]

Vlookup+match bhi laga sakte hai kya

[@ExcelUniverse]

VLOOKUP Se Reverse(Right to Left Lookup) Nahi Kar sakte hai. Either you need to make a complex formula using choose or use this index match for older version of Excel

[@rabinamagar7166]

👍👍👍👍🔥🔥🔥🔥

[@ExcelUniverse]

👍

[@shadowgaming23g57]

Shall we use reverse vlookuo

[@ExcelUniverse]

Yes, But not user friendly, instead of that INDEX+MATCH is more flexible. Even in new version of Excel have XLOOKUP function that lookup data in any directions

[@debasisbhattacharya5913]

Sir iske liye Excel version kiye 2016 ?

[@ExcelUniverse]

Kisi V Version Me chalega

[@piyushawana8192]

Is working but data in coming in sequence only, unlike yours where columns are not in the same sequence but data coming as per column name, plz help

[@ExcelUniverse]

Can you pls share the sample file where you applied formula. Whatsapp @ 9708153000

[@omegaxxi5405]

Everything is working but it seems wrong data in respect to employee code . Why?? Either it may be freez problem or other?

[@ExcelUniverse]

May be, I need to check. Please formula you applied. Whatsapp [phone]

[@omegaxxi5405]

Thanks a lot 🙏 Bahut hi acha tarika se samajhe..... Anyway jo problem tha wo solve ho gaya hai ..... ❤

[@ramsbisht9654]

Why cntrl + enter

[@ExcelUniverse]

If you select a range and wants to apply same formula entire range without copy paste. Just write formula and press ctrl entr

[@DHRUV.SUTHAR]

i hope hum jldi smaj jaye

[@ExcelUniverse]

🤔

[@ankuragarwal2988]

I want to changs data base bt not going in data base Is there any method

[@ExcelUniverse]

Please explain what exactly you want Whatsapp me 97081 53000

[@prasanthmunagala8811]

this formula is tooo difficult to remember so we can use the vlookup directly continuesly

[@ExcelUniverse]

VLOOKUP cannot lookup in reverse, you need to use XLOOKUP if you have excel 365 or excel 2021

[@ultron5690]

To bhaiya xlookup lga do na

[@ExcelUniverse]

XLOOKUP Function Excel 2019 or Isase Purane Version me Nahi hai.

[@sinister534]

Subscribed

[@ExcelUniverse]

😊

[@sinister534]

@@ExcelUniverse bhai chatGPT ke bhi shorts and videos banao plz,kese use kertey he chatGPT

[@md.shorifulislam8366]

How to get this dynamic ???

[@ExcelUniverse]

Can you please explain in detail how you want?

[@KaranDev4455]

sir can we use vlookup+match here? please reply.

[@ExcelUniverse]

No, because vlookup work in left to right direction. Well you can use xlookup which is available in office 365 or in office 2021 version

[@KaranDev4455]

@@ExcelUniverseSir, Does Index + match works only for right to left?

[@ExcelUniverse]

It works in all direction like left to right or right to left also top to bottom. Checkout the link below kzbin.info/www/bejne/moTQhnquZcRlm6M

[@harsh2848]

No need to learn this. Just learn how to use X Lookup. It can do pretty everything.

[@ExcelUniverse]

XLOOKUP :- kzbin.info/www/bejne/fnLRkp1oZsmrr7s

[@samratsaha3346]

can you share the data set

[@ExcelUniverse]

Which dataset

[@samarbisht5350]

Sir aise hee kar Raha hu wo ek hee jaisa paste kar dera poori sheet pe

[@ExcelUniverse]

Please share file where you applied formula. Whatsapp at 97081 53000

[@Shashankbaranwal]

sir mai practice k liye 1st sheet k large data se 2nd sheet me index match function k through selected info nikal raha hu but error jaisa kuchh find kr raha hai.

[@ExcelUniverse]

Aapne Jis File me formula Lagaya, wo file mujhe Whatsapp Par Share Kariye @ 9708153000

[@Shashankbaranwal]

@@ExcelUniverse ok i will

[@himanshuhimanshu2097]

Sir last Wale match mein mein lookup colume freeze nahi h

[@ExcelUniverse]

Last Wale MATCH Me row freeze hoga, column nahi

[@amitskill8461]

Freege kar rahe o kon bolega sir .

[@ExcelUniverse]

😊🙏

[@garimajoshi7054]

Ctrl+enter is not working

[@ExcelUniverse]

What happens when you press Control+Enter? Well you can share your file on whatsapp @9708153000

[@garimajoshi7054]

@@ExcelUniverseSir, actually ctrl+enter keys working but, it only gives a particular cell ka answer. It required to apply formula in each cell individually Eg. - Like when you pressed (ctrl+ enter) you get the entire table ka answers in one go. How???

[@ExcelUniverse]

Before you going to apply the formula, you need to select the entire range where you want to apply the formula, then input your formula and press control+enter

[@tanweerabbasabbas649]

dear its because of & signs. we need to put correctly✅️

[@lyricsliberty533]

Vlookup kyon nahi laga sakte hai

[@ExcelUniverse]

Vlookup Sirf left to right hi work karta hai. Well VLOOKUP ke sath CHOOSE function laga sakte hai, but wo Thora complicated hai.

[@lyricsliberty533]

@@ExcelUniverse thanks

[@VinitSingh011]

Website bhi match krva sakta hai kya

[@ExcelUniverse]

Yes

[@mohitparjapati4553]

Is it work Excel 2007 ?

[@ExcelUniverse]

Yes

[@Engineering4675]

Data validation

[@ExcelUniverse]

🤔

[@sajjadshaikhofficial3244]

Whenever I use the same formula but all values are coming Same. Can someone help me

[@dennyworldmovie7099]

Bro

[@dennyworldmovie7099]

Wat is the issue

[@ExcelUniverse]

Watch the video carefully and check where are dollar $ sign applied in the formula

[@ihgamingfun6295]

I think dis is somewhat long.. 🤔🤔

[@ExcelUniverse]

If you have Office 365 or newer version of Excel, XLOOKUP function is there and it's very powerful and dynamic function to do lookup. checkout the link below to know more. Video1 kzbin.info/www/bejne/fnLRkp1oZsmrr7s Video 2 kzbin.info/www/bejne/Z2bdmoiehNVgaa8

[@Qi_Abil]

Gg broo

[@ExcelUniverse]

👌

[@lightningeagle5087]

Freeze ke baare mein kaun batyega 🤦🤦

[@ExcelUniverse]

🙏

[@adefajar15]

Great video! btw may I know, what kind of software to record this vertical or portrait video yet still can move horizontally with zoom in and out feature?

[@ExcelUniverse]

Camtasia Filmora

[@adefajar15]

Ah I See, so it requires 2 softwares right, Camtasia and Filmora @@ExcelUniverse

[@mmmchamp9292]

I GAINED KNOWLEDGE

[@ExcelUniverse]

👍

[@gagandeepsingh-hz8xf]

Is file ka data mil sakta h formula applying karne ke liye

[@ExcelUniverse]

kzbin.info/www/bejne/hYPRZJtqgNSBppY Is video ke description me file download ka link mil jayega

[@gagandeepsingh-hz8xf]

@@ExcelUniverse thank you

[@mithoon1890]

Muze explain video chaiyr

[@ExcelUniverse]

kzbin.info/www/bejne/hYPRZJtqgNSBppY

[@Sasipatidar]

Lookup se bhi answer aa jata he

[@ExcelUniverse]

Yes

[@Sasipatidar]

Par mene dekha he kabhi data a to z nahi he to bhi sahi answer aa raha he esa kyu

[@ExcelUniverse]

Aap wo file share Kar sakte hai? Whatsapp [phone]

[@Sasipatidar]

@@ExcelUniverse ok

[@theinsuranceadvisorlic5312]

Sir I tried 10 time but no answer

[@ExcelUniverse]

Can you please share file where you applied formula. Whatsapp at 97081 53000

[@dvaibhav1]

Very fast video...

[@ExcelUniverse]

Sorry for that

[@dvaibhav1]

@@ExcelUniverse Please make the same video slow and in detail so that everyone can understand....👍

[@ExcelUniverse]

kzbin.info/www/bejne/moTQhnquZcRlm6M

[@dvaibhav1]

​​@@ExcelUniverse Link is not opening and not copying also...

[@ExcelUniverse]

Whatsapp me 97081 53000

[@TagwithCks]

bhai ctrl+shift+enter hota h

[@ExcelUniverse]

Array Formula Ke liye Ctrl+Shift+Enter press karna hota hai.

[@KoolCox]

Ab enter se hi ho jata hai

[@ExcelUniverse]

Yes

[@Xmenrinkuhindustani4525]

find only Name but Not show contact and email show #N/A

[@ExcelUniverse]

Can you share your file with formula you applied, @ Whatsapp @9708153000

[@pramodmamgain5279]

Same Issue Sir

[@user-vy9ok6me3r]

F4 kitne bar dabana hai ye kon bolega

[@ExcelUniverse]

Checkout the link below to know why use dollar in formula, kzbin.info/www/bejne/rquVeGV4oLxjp8k

[@mithileshdalvi56]

abe bhai range aage b le sakta hai na

[@ExcelUniverse]

👍

[@mithileshdalvi56]

@@ExcelUniverse what if lookup value ke corresponding values multiple rahege?

[@kautilyamishra4206]

It’s not working

[@ExcelUniverse]

Please share file where you applied formula. Whatsapp [phone]

[@arnabbanerjee9692]

#N/A kar decraha hai

[@ExcelUniverse]

Pls share file on WhatsApp [phone]

[@deepaksharma-bl9ld]

It's not working

[@ExcelUniverse]

Please share file where you applied formula. Whatsapp at 97081 53000

[@bhojpuri.wala07]

not working

[@ExcelUniverse]

Please share file where you applied formula. Whatsapp at 97081 53000

[@poojachauhan8893]

Well explained 😅

[@ExcelUniverse]

😊

[@RohitKumar-cc7zi]

I given you dislike as you given Wrong and incorporated info, why not tell to freeze row And column. ????????????? Totely Wrong, disliked you

[@ExcelUniverse]

Will take care of it. Thanks for your feedback