Bro mene aabhi tumhari file cheak ki jo tumna bataya vo jhoot h Mene Excel 2021 mai aabhi tumhari file check ki Normal vlookup mai :- 10 second laga And tumhare formula try kiya to 40 second 🤦
It is very likely that you VLOOKUP is already optimized for speed. But for old versions of excel this technique works beautifully. See this documentation from Microsoft (under speed lookups) - learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-tips-for-optimizing-performance-obstructions
Sir please next video on X lookup basic to advanced, Index match basic to advanced, Power query basic to advanced, Left, right, mid basic to advanced 1 industry level projects Pls 🙏🙏🙏🙏🙏🙏 sir 😊
![Advance Filter on Large Data in Excel | Filter vs VLOOKUP | [Hindi] #excel](http://i.ytimg.com/vi/U_pj0V5EOm4/mqdefault.jpg)
Download the Excel File ⬇ - goodly.co.in/wp-content/uploads/2024/11/Fast-Vlookup-on-large-dataset-in-Excel.xlsx
Find Duplicate Values in VLOOKUP - ua-cam.com/video/f32eQV3Vg-8/v-deo.htmlsi=eQS0Ds-7bGaEfOcf
11 Zabardast Excel Tricks - ua-cam.com/video/NqrSUmPZ2sQ/v-deo.htmlsi=2NR2gEpvHsXzZs3G
Bro mene aabhi tumhari file cheak ki jo tumna bataya vo jhoot h
Mene Excel 2021 mai aabhi tumhari file check ki
Normal vlookup mai :- 10 second laga
And tumhare formula try kiya to 40 second
🤦
It is very likely that you VLOOKUP is already optimized for speed.
But for old versions of excel this technique works beautifully.
See this documentation from Microsoft (under speed lookups) - learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-tips-for-optimizing-performance-obstructions
गजब मजा आ गया
Sir please next video on
X lookup basic to advanced,
Index match basic to advanced,
Power query basic to advanced,
Left, right, mid basic to advanced
1 industry level projects
Pls 🙏🙏🙏🙏🙏🙏 sir 😊
Next will be on Google sheets. I'll make a video on Xlookup tricks after that. thanks for the suggestions 😃
Another Cood tricks
Sir thank you thanks a lot
Hello sir ,Dono jagah false(0) formala lga ke bhi fast formula lg skta hai kya
on a large data .. it might crash your excel!
sir plz provide datasets for practice .....
goodly.co.in/wp-content/uploads/2024/11/Fast-Vlookup-on-large-dataset-in-Excel.xlsx
Please course start in hindi
🤨🤨
Practice file kahan hai ?
goodly.co.in/wp-content/uploads/2024/11/Fast-Vlookup-on-large-dataset-in-Excel.xlsx
Yaar Chandeep, ki appaan, Vlookup dee jagah Xlookup nee la sagde, es file de ander ?
Not working this trick aur speed kharab kar diya
check your formula, make sure search type is set as 1 not 0.