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 !

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.

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.

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 😊

Thanks for the clear and detailed explanation of the Xlookup function

Sumit, Thanks for sharing your knowledge! Your explanations were very clear.

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!!

Thank you very much for this super cool video, for this valuable and practical information, and for this unique approach.

Your communication skill and teaching skill both are excellent

AMAZING video!!! OMG! Thanks a bunch, Master!!!!

Amazing video - the best on this topic. Thanks for posting it.

Thanks, I found to be a wonderful and valuable information.

Very clear and very well explained, absolute beauty!

Thank you very much for all the great information.

Nicely done, Sumit. Thank you for the instruction.

This is new for me. I'm thankful to see your video as i learn one new option today.:)

A crear explanation Sumit. Thank you very much!

Sumit, What an awesome video about the fabulous new XLOOKUP excel function. Thank you SO MUCH

@trumpexcel

4 жыл бұрын

Glad you liked it Pat!

a beginner in excel and wow!!! xlook up is made easy! thanks you!

Explained very well.... Many thanks.

thank you! I finally figured my formula out.

Well explained with different examples. Thank you

Thank u... Very well explained

This was great. Thank you so much!

so much effort I could have avoided had I know. Thanks

Always great video ♥

Hi Sumit, thank you - i found your video extremely useful!

well explained, thank you very much

This is so helpful! Thank you very much.

Thanks so much for the tutorial... its very helpful

Wow. Great function. Very nice explanation. Thank you so much

@trumpexcel

3 жыл бұрын

Glad you liked it :)

Thank you very much for your such valuable explanation. Great!

Thanks heaps. Well explained.

More than perfect.. well done..

Great Work..4E... excellently explained entire entries

Thanks a lot for your guidance 🙏👍❤️❤️❤️

Great, thanks a lot its really very helpful, explained so nicely and in layman which is easily understanable

Excellent information about xlookup function thankyou very much sir.

Waou !! Amazing presentation. Thank you for your great explanation.

Gr8, very good video explaining various uses of xlookup 👍👍

Thank you very much. How to search in a range of Data 2 columns but the return range is only 1 column ?

Very well explained. Nice

Great learning.. Thanks

Great video. Thank you.

Thank you so much for sharing

You are very great explainer in ever Excel videos

Thank you for sharing this! I have a "value" error problem, but I dont know how to fix. Can you advise? Thanks

Thanks, Very helpful

Awesome. Hands up. Keep it up

Brilliant video Sumit

Very helpful video sir thank u

thanks, helped a lot

Superb presentation .......

Excellent job sir

Thank you for your efforts

@trumpexcel

4 жыл бұрын

Glad you found it useful!

Really great tutorial thanks

@trumpexcel

4 жыл бұрын

Glad you liked it Brain!

Great video buddy

Very useful bro keep it up

Very useful information

Great examples! Thank you :-)

Thank you Sir.

Hi Sumit, Thanks a lot for the Great information & The wonderful explanation simplified but when I added "Didn't Appear" even if the searchable value is available the formula result is # value. How I can solve? please help

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.

@trumpexcel

Жыл бұрын

I know the feeling. Glad to the know the video helped :)

In ex 10 can you pls explain why you used 2 commas at the end of the formula before clicking on wild card character. Thanks

Thank you!!!!

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.

many many thanks

Very good !

Hi Sumit, it's really amazing. I just have a query - Can we get value applying multiple criterion, as we do in Indexmatch!

Thank you master guru

Thank you so much for the explanation. I have done a look-up for the entire value (around 5:22min). However the results are horizontal and I would like to have them vertically. How can I transpose the column? Thank you in advance.

@shivakumarreddy7132

2 жыл бұрын

Copy the entire table and then taste special by pressing ctrl+alt+v and you will a find called transpose click on transpose. Now you data will convert vertically

Thanks for the video. How can we reference the return array from another sheet if we know the number of the column? Like if I am in one sheet and want to return the second column (2) from another sheet (sheet!B:B)? I want column B:B from the second sheet being linked to a number, so became dinamic? Is it possible?

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!

This is great information. Can you use xlookup in Excel 365 to find values in other versions of Excel?

@trumpexcel

4 жыл бұрын

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

Can u create video using same formula for duplicate values.? How can we find output if lookup value has duplicates?

Superb!

Very Interesting

I have an ecxcel sheet with annual summaries of some figures which are against separate account headings. Max value I can find but i want to see this amount is against which heading. Xlookup can be used if you know the searching array. Here i can find it manually but need it be by excel. Hope u got my problem. Eg 2018, 2019 etc separate(exp income profit etc under each year).

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?

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.

What about if there are more than one highest scorer with same mark in one subject?

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.

Superb

Great video - I'm guessing those thumbs down videos are other Excel KZread posters...?

Super sir

Hi, can u please make a video on how to fetch student's name who scored more than 99.. @22:33

Thanks

What if the label are different sequence ? how to use it?

Sir, can we use this in Google sheets?

Nice Job Sumit . Please Is it possible to return a data in Excel base on Selection

Question: I have an Excel invoice with hundreds of different items. How would I check that vendor is always charging the same price per item? What function would I use. Filter is too cumbersome. Thanks.

What if you want "Not appear" for the dual xlookup?

How ahout multiple look-up cakes???. Could you please illustrate that with an example.

Amazing.

@trumpexcel

3 жыл бұрын

Glad you found the video useful!

Hi very nice video, however I am unable to download the file used as example

Hi! how can I do this? "The scope is to match items from column A in Tab xxxxx to the items from column B from Tab yyyyyy??? .

Superb source of very valuable advice. Thanks very much. Bye-Bye Vlookup !

@trumpexcel

4 жыл бұрын

While I am huge a fan of VLOOKUP and INDEX/MATCH, this indeed is Bye-Bye VLOOKUP :)

nice sir ji.

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’?)