Honestly saying here that it the way we develop and make our future brilliant and sunshine.very nice art of teaching dear sir.keep continue good lectures on good contents.stay blessed always sir.
I am not able to lock the value through the F4 Key. When I go to press the F4 Key then Project section are open. You have any other soulution for locking.
Index match is more powerful than Vlookup because it allows operation on any row and column whereas vlookup only allows the lookup values to be left column.
Honestly saying here that it the way we develop and make our future brilliant and sunshine.very nice art of teaching dear sir.keep continue good lectures on good contents.stay blessed always sir.
the way you explain its wonderful
I succeeded this formula from yr video...I done this
Appreciate it
Thank you so much sir ❤
Index match formula puri TH-cam pr is sy behtr nhi h ❤❤
I appreciate the example, it would be more appreciable if you have explained the formulae first and then the example.
Thanks 👍
Thank you sir
You are mostly welcome. Stay tuned for latest videos. Requesting you kindly participate in our giveaway contest on 22nd December, 2022
Shukriya
I am not able to lock the value through the F4 Key.
When I go to press the F4 Key then Project section are open.
You have any other soulution for locking.
use Fn+F4 Key
Nice sir ji , thank you
why don't you provide the excel data sheet for practice?
Thankyou sir
Thank you sir!!
Soo good tq sir 🎉
Keep it up 💯
One day before exammmmmm
Timing - 11:43 pm
Date - 27/dec/2024
Hello sir ma Gilgit Baltistan pakistan sy hu.kia hum MS Excel sheet ma Auto Border laga skty hain?plz
Main samjha nahin, please explain
Vlook up bhi to kr skta h ye km name k basis pr sales nuklna
Thanks sir
You are mostly welcome. Stay tuned for latest videos
we can also use Vlook up function right
Which is more powerful Vlookup Or Index match????
Index match is more powerful than Vlookup because it allows operation on any row and column whereas vlookup only allows the lookup values to be left column.
Can we use same data Xlookup formula ?
Vlookup laga kar bahut easily kar sakte hai
Sir, pls also have been shared Excel file for each vedio
How about pivot table as an alternative for this
Badhiyan
F4 key laptop me ni kam krta ab ap dusra formula btaiye jisse ham lock krske
use fn+f4
How to match 3 values in excel?
Match formula 3 times with index not working.
we can do this in pivot table . then why should i use this large formula??
Vlookap se bhi to ho sakta h na
Brother there is a problem while applying this formula sales 2019 is #N/A every time.while other 2vis correct
bhai jas rata ke formula kya fayda at least you want explain why this is used....
Sales ko ap upar niche kayse sajaye ho ?
Hame kaise pata lage ga kon si value lock krni hai Formula mai btw nice video Do Reply plz
yeh simple process kahi se nahi tha smooth video banaiye isse bhi better.
Xlookup achha hai.
Sir I am same step you which have done but ans is not showing #N/A sir please reply
Bhot bada formula h yaad bhi hona chahiye
Sir i am not aboe to drag the data .it shows NA.CAN U PLEASE EXPLAIN
Sir, hamre mae #N/A dikha raha, plz tell me kaha par mistake ho rahi
can you share the data set?
Need to provide Sheet
Very complex.
Can't understand and remember for only one single thing
#N/A aa rha h
can u provide practice file sir ???
Sir error aata h
Very lengthy
Itna big formula😮😢
Isse achha or asan to Vlookup hai...🤐
Not working ,my 1 hr wated on trying this formula
Thank you sir
You are mostly welcome. Stay tuned for latest videos
Thank you sir
thank you sir