Xlookup formula | Filter Formula | Xmatch formula | Sort formula | Unique formula| Excel tricks 2020

[@ishwarsingh881]

Excellent clarification

[@GyanOnTube]

Thank you so much Ayushman Singh ji..bus aap logo ka support chaiye

[@nareshbhagmal]

Superb video

[@GyanOnTube]

Thank you so much Naresh Mawana ji..bus aap logo ka pyar hi hai ki mein videos aap logo ke liye bana pata hu.. please share this video with your friends and family.

[@mohanpal13555]

Awesome trick

[@GyanOnTube]

Do not forget to share this video mohan

[@ChandanDas-wl2uk]

💓💓

[@GyanOnTube]

Bahut bahut shukriya

[@jksunique2463]

Xlookup ko ek se jyada sheets me kaise use karenge please share one video

[@GyanOnTube]

Very nice and valid question Jitendra ji..will make a video on it soon

[@akhileshshahi7731]

Really excellent video.

[@shabadke]

ur vedios are very simple to understand. have u made any vedio on power query?

[@GyanOnTube]

Shabad ke ji..mene power Query ke uper to nhi Power picot and Power BI ke upper bahut si video bana rakhi haj..agar aap Power query mein kuch bhi changes karte ho to wo power BI mein hi open hoti hai..aap mera power bi ka playlist check kar sakte ho aapko aur knowledge milegi..

[@mbc1557]

Sir, Does these formulas can run on MSExcel 2019?

[@GyanOnTube]

As of now these are only available in office 365..

[@puspenderkumardubey1732]

सर कृपया 2 शीट में डेटा का खोजना बताइये

[@GyanOnTube]

Sure mein iske uper ek video lata hu bahut jald

[@puspenderkumardubey1732]

@@GyanOnTube thanku sir I m waiting

[@SomethingDiffrent.]

Sir I have one question? Ul. Pl. Shri. Man1. 20. 15. 10 Man1. 12 12. 5 Man2. 34. 65. 76 Man1. 43. 54. 54 Ul. Pl. Shri. Man 1 Man 2 I want find out sum (unplanned planned & , shrinkage )of these 2 man ger 1 & 2 in single formula how can I do that?..pls reply

[@GyanOnTube]

Very nice question 👌..you can apply sumfis() in array formula with multiple criteria to get the value.

[@SomethingDiffrent.]

@@GyanOnTube but how I do that I am trying lot more time after got one value other are blank.and I like your video sir very interesting.

[@GyanOnTube]

@@SomethingDiffrent. ok let me work for you and will send you the Formula

[@SomethingDiffrent.]

Thank u sir... giving this response

[@SomethingDiffrent.]

@@GyanOnTube Sir can got the answer?

[@subramanyannv9858]

Can you please give information on how to free install xlookup. The "i" you mentioned towards the end of the video doesn't appear to me.

[@GyanOnTube]

Subramanyan NV ji..thank you for watching this video..you can use the below video link to download XLOOKUP. kzbin.info/www/bejne/bmKai2uLZ6aFe9k

[@mooodffreshinoneminut5103]

सर। मेरे पास एमएस ऑफिस सेवन है। मैं उसमें एक Xlookup कैसे यूज कर सकता हूं

[@GyanOnTube]

Very nice question 👌 ..aap office insider 365 intall kar lijiye bilkul free hai..pura video dekho aap free mein install kar loge..

[@mooodffreshinoneminut5103]

Taknk you.