I’m learning excel and you explain everything to clearly! Thank you. I haven’t found a video yet that shows how to pull data from a different sheet using xlookup. Trying this tomorrow! Subscribed to learn more 😊
Helpful isn't the word. I had to scrub a warehouse inventory of 1,565 individual parts against a bill of materials in excess of 2,500 lines. This video just saved my soul from destruction.
Very helpful, and very clear. I am going to start converting some VLOOKUPs right away because I can see X removing quite a few potential issues down the road.
OMG.. You made my work a breeze. I had wanted to find a formula which would return the most recent instance of lookup value and couldn't find any video which explained it. Thought would have to sort all my data in descending order to get it but that would mean sorting each time I added to the table 😅. This video gave me exactly what I wanted without messing with the order. Thank you so very much!!
Finally I got it to work. I created a new sheet and then it worked. thanks. Can you please go slower next time, and don't assume people know where you click. Never assume.
What about when looking up a record that has multiple entries? - For example, what if there were three Greg names in the file, and you wanted to see all three, but still only show 1 name if there were 1 Amy match, or 2 names if there were two Stan matches?
Great tutorial! With the power of Excel 365, I have to believe the Excel C++ code would probably go to the moon and back! Next release Excel will probably ask: "Want a coffee with that spreadsheet"? LOL
Please show how to analyse a personal bank statement in Excel into Account heads like Bank Int.,Salary,bank charges, family transfer,interbank TRF.,etc. along with Account Group like Income,Exps.,Bank transfers,etc. asap.thanks Bansalji 🙏👍
Brother your information is very good but we can not see the actual formula coz your subtitles are hiding all the info which you are showing in the sheet. However please remove the subtitles from your screen.
Got a question. What if I wanted to search for a value in multiple non continuous columns and return they adjacent cell. For example, look up a value in a1 and look up array in b1 to b5 and return c1 to c5 but also do the same for a second lookup array in e1 to e5 with return f1 to f5. So if value from a1 is found in b OR e it will return whats in c or f. Hope that makes sense.
Hi, This was really useful. But all the examples had names as unique identifiers - i.e. there was only 1 Greg and 1 Amy. Is this useful of you have three Gregs? It will be really helpful to understand if the unique identifier is duplicated, what are the options. Thanks!
If you can open all the files with Excel 365, you can use it. XLOOKUP doesn't have backward compatibility though, which means that if you open a workbook which has XLOOKUP in a version that doesn't have XLOOKUP, it will show an error
I really enjoyed your video. I have been working on a menu planning project and have run into a brick wall. In your video on XLOOKUP, you mentioned that a single search can return multiple records. I'm trying to do just that.Can a single drop down item return several items from other data sets? Example: In a Breakfast category selecting "Breakfast Burritos" I would need to return its ingredients from three data sets into cells: items from a Protein data set, items from a Carbs data set and items from a Fats data set. Using the Burrito example, Eggs would be pulled from the Protein set, Wheat Tortilla from the Carbs set and, Sausage and Cheese from the Fats set and all placed in specifically selected cells. Other drop down selections would pull their ingredients from the appropriate lists. Thank you.
You can create a custom function with VBA that does some of what XLOOKUP can do. I am not sure if you can get all the functionality of XLOOKUP with VBA
I'm having troubles in showing all the ranges (20 numbers), provided the formula to get the first number =XLOOKUP(L6,C:C,D:D), and last number =XLOOKUP(L6,C:C,D:D,"",2,-1), but what I want to display is the entire range, which is 20 numbers, can you help?
I double clicked on the fill handle. When you select a cell, you will notice a small green square at the bottom right. If you double click on it, it fills the column (based on how far the cells are filled in the adjacent column)
@@trumpexcel There’s also a keystroke for this. I just can’t find it. I use more keystrokes in Office than I do mouse (sometimes mouse plus key). I especially like the shift-space to select a row for doing headers (enter moves to the right instead of down).
@@garypoplin4599 The one I know is to select all the cells in which you want the formula result, then enter the formula in the active cell and then hold the Control key and press Enter. This will flll the formula in all the selected cells
Thank you! The previous videos on the same subject I just watched were unintelligible. Your explanation was much clearer and easier to understand.
I can not express how much I appreciate your work, Thank you very much Sumit !
I’m learning excel and you explain everything to clearly! Thank you. I haven’t found a video yet that shows how to pull data from a different sheet using xlookup. Trying this tomorrow! Subscribed to learn more 😊
Helpful isn't the word. I had to scrub a warehouse inventory of 1,565 individual parts against a bill of materials in excess of 2,500 lines. This video just saved my soul from destruction.
I know the feeling. Glad to the know the video helped :)
Your communication skill and teaching skill both are excellent
Best video on the XLookup that I have seen. A must see. Honestly, I love all of his videos. But this one is my favorite of all of his work.
Very helpful, and very clear. I am going to start converting some VLOOKUPs right away because I can see X removing quite a few potential issues down the road.
This is new for me. I'm thankful to see your video as i learn one new option today.:)
OMG.. You made my work a breeze. I had wanted to find a formula which would return the most recent instance of lookup value and couldn't find any video which explained it. Thought would have to sort all my data in descending order to get it but that would mean sorting each time I added to the table 😅. This video gave me exactly what I wanted without messing with the order. Thank you so very much!!
Finally I got it to work. I created a new sheet and then it worked. thanks. Can you please go slower next time, and don't assume people know where you click. Never assume.
Amazing video - the best on this topic. Thanks for posting it.
Can I like this video twice?
Sumit, What an awesome video about the fabulous new XLOOKUP excel function. Thank you SO MUCH
Glad you liked it Pat!
a beginner in excel and wow!!! xlook up is made easy! thanks you!
Thanks for the clear and detailed explanation of the Xlookup function
Great video - I'm guessing those thumbs down videos are other Excel CZcams posters...?
You are very great explainer in ever Excel videos
Great, thanks a lot its really very helpful, explained so nicely and in layman which is easily understanable
More than perfect.. well done..
Thanks a lot for your guidance 🙏👍❤️❤️❤️
Very well explained. Nice
Wow. Great function. Very nice explanation. Thank you so much
Glad you liked it :)
What about when looking up a record that has multiple entries? - For example, what if there were three Greg names in the file, and you wanted to see all three, but still only show 1 name if there were 1 Amy match, or 2 names if there were two Stan matches?
Excellent information about xlookup function thankyou very much sir.
so much effort I could have avoided had I know. Thanks
Well explained with different examples. Thank you
Thank you very much for this video. Please make a video on how to fetch all student's name who scored the highest marks @22:33
Waou !! Amazing presentation. Thank you for your great explanation.
Great tutorial! With the power of Excel 365, I have to believe the Excel C++ code would probably go to the moon and back! Next release Excel will probably ask: "Want a coffee with that spreadsheet"? LOL
Hi Sumit, thank you - i found your video extremely useful!
Very clear and very well explained, absolute beauty!
Great Work..4E... excellently explained entire entries
I liked the video. It was very educational but the ads were too much.
Excellent job sir
Thank you so much for sharing
Sumit, Thanks for sharing your knowledge! Your explanations were very clear.
Very helpful video sir thank u
Great video. Thank you.
Very useful information
thank you! I finally figured my formula out.
Please show how to analyse a personal bank statement in Excel into Account heads like Bank Int.,Salary,bank charges, family transfer,interbank TRF.,etc. along with Account Group like Income,Exps.,Bank transfers,etc. asap.thanks Bansalji 🙏👍
Nicely done, Sumit. Thank you for the instruction.
Awesome. Hands up. Keep it up
Thank you very much for your such valuable explanation. Great!
Great video buddy
Thank you Sir.
Explained very well.... Many thanks.
Nice Job Sumit . Please Is it possible to return a data in Excel base on Selection
Thank you master guru
many many thanks
Brother your information is very good but we can not see the actual formula coz your subtitles are hiding all the info which you are showing in the sheet. However please remove the subtitles from your screen.
This is so helpful! Thank you very much.
Thank u... Very well explained
Thanks so much for the tutorial...
its very helpful
Xlookup is 100 times better than it's precedents.
Very Interesting
Power Pivot:
Please do a series on Piwor Pivot. Thanks.
Got a question. What if I wanted to search for a value in multiple non continuous columns and return they adjacent cell. For example, look up a value in a1 and look up array in b1 to b5 and return c1 to c5 but also do the same for a second lookup array in e1 to e5 with return f1 to f5. So if value from a1 is found in b OR e it will return whats in c or f. Hope that makes sense.
Superb source of very valuable advice. Thanks very much. Bye-Bye Vlookup !
While I am huge a fan of VLOOKUP and INDEX/MATCH, this indeed is Bye-Bye VLOOKUP :)
AMAZING video!!! OMG! Thanks a bunch, Master!!!!
Really great tutorial thanks
Glad you liked it Brain!
What about if there are more than one highest scorer with same mark in one subject?
Thank you!!!!
Can you please upload your file again since I just can't download it? It blinks and then it does nothing. Thanks
Superb presentation .......
Great examples! Thank you :-)
Thank you very much for this super cool video, for this valuable and practical information, and for this unique approach.
Hi very nice video, however I am unable to download the file used as example
Super sir
Hi, This was really useful. But all the examples had names as unique identifiers - i.e. there was only 1 Greg and 1 Amy. Is this useful of you have three Gregs? It will be really helpful to understand if the unique identifier is duplicated, what are the options. Thanks!
Thanks heaps. Well explained.
Thanks, I found to be a wonderful and valuable information.
Thank you for sharing this! I have a "value" error problem, but I dont know how to fix. Can you advise? Thanks
This is great information. Can you use xlookup in Excel 365 to find values in other versions of Excel?
If you can open all the files with Excel 365, you can use it. XLOOKUP doesn't have backward compatibility though, which means that if you open a workbook which has XLOOKUP in a version that doesn't have XLOOKUP, it will show an error
9:28 - How can I use this functionto optionally add the record ‘Sam’? (I.e., pop up a dialog with the message “Do you want to add ‘Sam’?)
How ahout multiple look-up cakes???. Could you please illustrate that with an example.
Thank you very much for all the great information.
Thanks
Brilliant video Sumit
This was great. Thank you so much!
Thank you for your efforts
Glad you found it useful!
tRUMP, im about to break my computer trying to figure out the table language for xlookup! thanks for video.
nice sir ji.
A crear explanation Sumit. Thank you very much!
I really enjoyed your video. I have been working on a menu planning project and have run into a brick wall. In your video on XLOOKUP, you mentioned that a single search can return multiple records. I'm trying to do just that.Can a single drop down item return several items from other data sets? Example: In a Breakfast category selecting "Breakfast Burritos" I would need to return its ingredients from three data sets into cells: items from a Protein data set, items from a Carbs data set and items from a Fats data set. Using the Burrito example, Eggs would be pulled from the Protein set, Wheat Tortilla from the Carbs set and, Sausage and Cheese from the Fats set and all placed in specifically selected cells. Other drop down selections would pull their ingredients from the appropriate lists. Thank you.
13:50 You must explain why you are locking the values because a beginner would get confused
Thanks, Very helpful
What if you want "Not appear" for the dual xlookup?
Gr8, very good video explaining various uses of xlookup 👍👍
Hi Sumit,
Please tell how we can add xlookup in our existing excel using VBA. Thanks
You can create a custom function with VBA that does some of what XLOOKUP can do. I am not sure if you can get all the functionality of XLOOKUP with VBA
@@trumpexcel Thanks for replying. Please make a video on the same.
well explained, thank you very much
Very useful bro keep it up
Great learning.. Thanks
Thank you very much.
How to search in a range of Data 2 columns but the return range is only 1 column ?
thanks, helped a lot
I'm having troubles in showing all the ranges (20 numbers), provided the formula to get the first number =XLOOKUP(L6,C:C,D:D), and last number =XLOOKUP(L6,C:C,D:D,"",2,-1), but what I want to display is the entire range, which is 20 numbers, can you help?
Amazing.
Glad you found the video useful!
Can u create video using same formula for duplicate values.? How can we find output if lookup value has duplicates?
Excellent video, unfortunately, I cannot download the excel file.
16:30 - Wow! That was cool! What keystroke did you use to get that formula to fill down!?
I double clicked on the fill handle. When you select a cell, you will notice a small green square at the bottom right. If you double click on it, it fills the column (based on how far the cells are filled in the adjacent column)
@@trumpexcel There’s also a keystroke for this. I just can’t find it. I use more keystrokes in Office than I do mouse (sometimes mouse plus key). I especially like the shift-space to select a row for doing headers (enter moves to the right instead of down).
@@garypoplin4599 The one I know is to select all the cells in which you want the formula result, then enter the formula in the active cell and then hold the Control key and press Enter. This will flll the formula in all the selected cells
@@trumpexcel _Thats_ the one I was hunting! Thanks.