#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)
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.
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
It works in all direction like left to right or right to left also top to bottom. Checkout the link below ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-dSmUGx0_2eA.html
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
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HAnaj21dxyY.html Video 2 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-15ziUhOp-3M.html
@@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
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.
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?