#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.
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
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.
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
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)
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
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.
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
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
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?
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.
@@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???
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
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 th-cam.com/video/HAnaj21dxyY/w-d-xo.html Video 2 th-cam.com/video/15ziUhOp-3M/w-d-xo.html
Xlookup also very helpful for this example
XLOOKUP is the most powerful function, but it's available in office 365 or in newer versions.
whenever I need it, simply watch your short, really helpful
I'm glad to hear it, and it inspires me to create such useful content, thanks a lot.
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
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.
Xlookup will be easy
Yes It's very easy to use, but available in Office 365 or Office 2021
Thank you so much! gain a subscriber for life.
Glad it helped!
Thanks Bhai apki vajah se mere 2 hour Bach Gaye,, apko suscribe kar liya he.. ese hi video banate raho.. 👍
🙏
Thanks very useful information 🙏
Most welcome
this kind of example are hard to see by others, thanks for such a wonderful example. Please give us more example with formula also .
Thanks for your valuable feedback
Thanks 🙏🙏 very useful for me .... God bless you
Thanks for your feedback 😀
Your short is good but you should have shown about the freezing the range
Thanks for your feedback, I must remeber next time.
Thx sir for this ❤ its so help full 😊
Most welcome 😊
Thank you lots of love
🤔
Good, Very Helpful and easily explained👍
🙏
Thank you very much, Really Really it is helpful for me as well as others also, once again Thank you for knowledge sharing.
It's my pleasure 🙏
We can use reverse Vlookup instead of index+match, btw nice video..
Yes, you are right
THANK YOU SO MUCH
Most welcome 🙏
Jaaduu. Briliant Brother
Really 🎩 🪄
this is awesome
Thanks 🙏
Thank u thank u so much sir
Most welcome
Very nice
Thanks
Thank u so much
Most welcome 😊
Thanks
Welcome
Bro pls mention about cell lock F4. Who are Fresher they won't be able to understand
Thanks for your suggestion 😊
If f4 doesn't work..give function f4
Amazing video
Thanks!
Helpful.
Thanks Rajeev G
Thank you sir
Most welcome
Awesome
👍
Helpful information👍
But Can we use Dget function instead of index+match function?
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.
@@ExcelUniverse Thanks
🙂
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 😂
🤔
Thankyou bro
😊
Thank you sir km time mai amazing experience
Can we do the same with vlook with a match to get all the data.
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
Sir Xlookup bhi use kar sakte hai isme right?
Wo to sabse best option hai
कम से कम वक्त में फॉर्मुला सिखाने के लिए 🙏
धन्यवाद धन्यवाद धन्यवाद
😊
WOW SUPERB
Thanks 🤗
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
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)
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
As I understand you want to get records from the sheet you want?
thanks you👍🏻👍🏻👍🏻
Welcome 👍
idher xlookup function use kar sakte gai
Yes
My first row was taking the correct way but the down row was not taking
Please share your file where you applied formula. Whatsapp 97081 53000
But we can use x lookup right?
Yes
But it's available only in Microsoft 365 and Microsoft 2021
Did not work showing #N/A error please help
Share your file with formula you applied. WhatsApp @ 9708153000
In this case, Xlookup might be more easier than this.
Yes you are right, but XLOOKUP available only in Excel 365 or Excel 2021.
sir can we use vlookup+match here? please reply.
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
@@ExcelUniverseSir, Does Index + match works only for
right to left?
It works in all direction like left to right or right to left also top to bottom.
Checkout the link below
th-cam.com/video/dSmUGx0_2eA/w-d-xo.html
How to show all matching values for a match in range
Use MATCH function to match the record
Please make more videos
sure
jordar
✨️🙏
Horizontal format mai bhi hum index match laga sakte hai
Yes, checkout the link below for more detail on INDEX MATCH
th-cam.com/video/ORn3h4KoNp4/w-d-xo.html
Subscribed
😊
@@ExcelUniverse bhai chatGPT ke bhi shorts and videos banao plz,kese use kertey he chatGPT
Vlookup bhi use kar sakte hain, but this is really quick
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
@@ExcelUniverse yes sir, Xlookup...I mistakenly typed Vlookup 😅
😃
2 ghante computer class mai waste ho gaya iss per kyuki waha per unko theek se teaching krrna nhi aata
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.
Jitna excel ko seekhna ki koshish krta hu utna confuse ho jata hu
Jitni Jarurat utna sikhiye fir confuse nahi honge.
Well excel ke kuchh hi formule and functions hai jiski jyada jarurat hai.
@@ExcelUniversewhat an amazing reply .
how to free row
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.
Shall we use reverse vlookuo
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
Vlookup+match bhi laga sakte hai kya
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
what if some values have special characters like ba'diyah cause it not recognizeable
can you please share a sample file where you get error.
Because it's not showing any error at my end.
WhatsApp @ 9708153000
Sir iske liye Excel version kiye 2016 ?
Kisi V Version Me chalega
Trying the formula from few days but not succeeded. After watching this short able do it successfully. Thanks
It's my pleasure
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?
Camtasia
Filmora
Ah I See, so it requires 2 softwares right, Camtasia and Filmora @@ExcelUniverse
i hope hum jldi smaj jaye
🤔
can you share the data set
Which dataset
Xlookup .. much easier to use
Yes
I want to changs data base bt not going in data base
Is there any method
Please explain what exactly you want
Whatsapp me 97081 53000
How to get this dynamic ???
Can you please explain in detail how you want?
Everything is working but it seems wrong data in respect to employee code . Why??
Either it may be freez problem or other?
May be, I need to check. Please formula you applied.
Whatsapp 97081 53000
Thanks a lot 🙏
Bahut hi acha tarika se samajhe.....
Anyway jo problem tha wo solve ho gaya hai .....
❤
Why cntrl + enter
If you select a range and wants to apply same formula entire range without copy paste.
Just write formula and press ctrl entr
I am getting only first name to all selected cell for example Evan Zigomala...
Can you please share file where you applied formula. Whatsapp 97081 53000
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
Can you pls share the sample file where you applied formula. Whatsapp @ 9708153000
Is it work Excel 2007 ?
Yes
Gg broo
👌
Sir last Wale match mein mein lookup colume freeze nahi h
Last Wale MATCH Me row freeze hoga, column nahi
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.
Aapne Jis File me formula Lagaya, wo file mujhe Whatsapp Par Share Kariye @ 9708153000
@@ExcelUniverse ok i will
Website bhi match krva sakta hai kya
Yes
To bhaiya xlookup lga do na
XLOOKUP Function Excel 2019 or Isase Purane Version me Nahi hai.
Vlookup kyon nahi laga sakte hai
Vlookup Sirf left to right hi work karta hai.
Well VLOOKUP ke sath CHOOSE function laga sakte hai, but wo Thora complicated hai.
@@ExcelUniverse thanks
👍👍👍👍🔥🔥🔥🔥
👍
No need to learn this. Just learn how to use X Lookup. It can do pretty everything.
XLOOKUP :- th-cam.com/video/HAnaj21dxyY/w-d-xo.html
Sir aise hee kar Raha hu wo ek hee jaisa paste kar dera poori sheet pe
Please share file where you applied formula. Whatsapp at 97081 53000
Is file ka data mil sakta h formula applying karne ke liye
th-cam.com/video/ORn3h4KoNp4/w-d-xo.html
Is video ke description me file download ka link mil jayega
@@ExcelUniverse thank you
Freege kar rahe o kon bolega sir .
😊🙏
Whenever I use the same formula but all values are coming Same. Can someone help me
Bro
Wat is the issue
Watch the video carefully and check where are dollar $ sign applied in the formula
Well explained 😅
😊
Data validation
🤔
Ctrl+enter is not working
What happens when you press Control+Enter?
Well you can share your file on whatsapp @9708153000
@@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???
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
dear its because of & signs. we need to put correctly✅️
Sir I tried 10 time but no answer
Can you please share file where you applied formula. Whatsapp at 97081 53000
this formula is tooo difficult to remember so we can use the vlookup directly continuesly
VLOOKUP cannot lookup in reverse, you need to use XLOOKUP if you have excel 365 or excel 2021
Muze explain video chaiyr
th-cam.com/video/ORn3h4KoNp4/w-d-xo.html
I think dis is somewhat long.. 🤔🤔
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
th-cam.com/video/HAnaj21dxyY/w-d-xo.html
Video 2
th-cam.com/video/15ziUhOp-3M/w-d-xo.html
Lookup se bhi answer aa jata he
Yes
Par mene dekha he kabhi data a to z nahi he to bhi sahi answer aa raha he esa kyu
Aap wo file share Kar sakte hai?
Whatsapp 97081 53000
@@ExcelUniverse ok
bhai ctrl+shift+enter hota h
Array Formula Ke liye Ctrl+Shift+Enter press karna hota hai.
Freeze ke baare mein kaun batyega 🤦🤦
🙏
I GAINED KNOWLEDGE
👍
Very fast video...
Sorry for that
@@ExcelUniverse
Please make the same video slow and in detail so that everyone can understand....👍
th-cam.com/video/dSmUGx0_2eA/w-d-xo.html
@@ExcelUniverse
Link is not opening and not copying also...
Whatsapp me 97081 53000
abe bhai range aage b le sakta hai na
👍
@@ExcelUniverse what if lookup value ke corresponding values multiple rahege?
F4 kitne bar dabana hai ye kon bolega
Checkout the link below to know why use dollar in formula,
th-cam.com/video/xz2G2BkW0qg/w-d-xo.html
Ab enter se hi ho jata hai
Yes
It’s not working
Please share file where you applied formula. Whatsapp 97081 53000
find only Name but Not show contact and email show #N/A
Can you share your file with formula you applied, @ Whatsapp @9708153000
Same Issue Sir
not working
Please share file where you applied formula.
Whatsapp at 97081 53000
It's not working
Please share file where you applied formula. Whatsapp at 97081 53000
#N/A kar decraha hai
Pls share file on WhatsApp 97081 53000