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.
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
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
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)
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
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.
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
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](http://i.ytimg.com/vi/gAY9is-ahQY/mqdefault.jpg)
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](/img/tr.png)
This saved me! Thank you so much!
Glad it helped!
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.
Thank you so much! gain a subscriber for life.
Glad it helped!
वाह सर आपके इस वीडियो ने तो मजे ला दीए 👍🏻👍🏻
धन्यवाद 🙏
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
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.
Thanks Bhai apki vajah se mere 2 hour Bach Gaye,, apko suscribe kar liya he.. ese hi video banate raho.. 👍
🙏
Which software are you suing for smooth Zoom and Pan for video? Its so nice. Please update. Thanks
Camtasia
Thank you lots of love
🤔
Your short is good but you should have shown about the freezing the range
Thanks for your feedback, I must remeber next time.
THANK YOU SO MUCH
Most welcome 🙏
Thx sir for this ❤ its so help full 😊
Most welcome 😊
Jaaduu. Briliant Brother
Really 🎩 🪄
Thanks 🙏🙏 very useful for me .... God bless you
Thanks for your feedback 😀
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 🙏
Thank u thank u so much sir
Most welcome
Thanks very useful information 🙏
Most welcome
Thank u so much
Most welcome 😊
Amazing video
Thanks!
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
Good, Very Helpful and easily explained👍
🙏
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 😅
😃
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 awesome
Thanks 🙏
Very nice
Thanks
Thank you sir
Most welcome
Trying the formula from few days but not succeeded. After watching this short able do it successfully. Thanks
It's my pleasure
Thankyou bro
😊
thanks you👍🏻👍🏻👍🏻
Welcome 👍
Sir Xlookup bhi use kar sakte hai isme right?
Wo to sabse best option hai
We can use reverse Vlookup instead of index+match, btw nice video..
Yes, you are right
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
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?
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
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 😂
🤔
Thanks
Welcome
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
Xlookup will be easy
Yes It's very easy to use, but available in Office 365 or Office 2021
We can use vlookup
No
@@ExcelUniverse oh sorry that's my mistake
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
Awesome
👍
Why we have to put match function twice?
First for row and second for column header
Mera. Ni. Hua. H. Serf name aaya. Baki ke do colum aaya he ni
Pls share your file on WhatsApp 97081 53000
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)
Helpful.
Thanks Rajeev G
WOW SUPERB
Thanks 🤗
Sir iske liye Excel version kiye 2016 ?
Kisi V Version Me chalega
i hope hum jldi smaj jaye
🤔
कम से कम वक्त में फॉर्मुला सिखाने के लिए 🙏
धन्यवाद धन्यवाद धन्यवाद
😊
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
Please make more videos
sure
How to show all matching values for a match in range
Use MATCH function to match the record
Sir last Wale match mein mein lookup colume freeze nahi h
Last Wale MATCH Me row freeze hoga, column nahi
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
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
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
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
But we can use x lookup right?
Yes
But it's available only in Microsoft 365 and Microsoft 2021
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 .....
❤
How to get this dynamic ???
Can you please explain in detail how you want?
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.
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
can you share the data set
Which dataset
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
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 .
Did not work showing #N/A error please help
Share your file with formula you applied. WhatsApp @ 9708153000
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
jordar
✨️🙏
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
Website bhi match krva sakta hai kya
Yes
Is it work Excel 2007 ?
Yes
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.
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
Subscribed
😊
@@ExcelUniverse bhai chatGPT ke bhi shorts and videos banao plz,kese use kertey he chatGPT
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
Xlookup .. much easier to use
Yes
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
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
Lock agar nahi karengha to sb nhi ayaga
Yes
Ye formula to 256 columns ya 65536 row tak hota hai. Agar us se bada data ho to ye to nahi kaam karne wala hai
Aisa nahi hai, try once.
Freege kar rahe o kon bolega sir .
😊🙏
In this case, Xlookup might be more easier than this.
Yes you are right, but XLOOKUP available only in Excel 365 or Excel 2021.
To bhaiya xlookup lga do na
XLOOKUP Function Excel 2019 or Isase Purane Version me Nahi hai.
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
Data validation
🤔
Sir I tried 10 time but no answer
Can you please share file where you applied formula. Whatsapp at 97081 53000
👍👍👍👍🔥🔥🔥🔥
👍
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
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✅️
Speed Kam Karo sir bohat fast ho raha hai
Sure
abe bhai range aage b le sakta hai na
👍
@@ExcelUniverse what if lookup value ke corresponding values multiple rahege?
Muze explain video chaiyr
th-cam.com/video/ORn3h4KoNp4/w-d-xo.html
bhai ctrl+shift+enter hota h
Array Formula Ke liye Ctrl+Shift+Enter press karna hota hai.
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
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
Well explained 😅
😊
Ab enter se hi ho jata hai
Yes
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