Sir, you proved that you are an expert. I heard many were saying that Vlookup meant for the left to right but with your explanation, it states it is possible in vise versa sequence as well. Great sir. Thanks for your valuable hint
Mr. PK your presentation is really excellent. I learnt some tricks from your excel videos. How can I take up Table_array for Vlookup from another worksheet? If you have any other video pl mention the link.
I PK thanks for all your help and sharing these videos ...Pk I need you're help I want to calculate headcount required on a given day...I have aht, work type, and shrinkage % .do you have any tutorial for this. I will be very thankful for all your help on this
please upload a vedio on condition like if weight is 1 kg, amout would charge 50 rs. on every additional 500 grm weight 30 rs. extra charged. how we'll calculate this in excel
You are great and amazing!!!!!
Thanks🙏
Very nice function vlookup + choose teaching by you thank you
Sir, you proved that you are an expert. I heard many were saying that Vlookup meant for the left to right but with your explanation, it states it is possible in vise versa sequence as well. Great sir. Thanks for your valuable hint
Thanks for your valuable feedback
Sir, excellent explanation.
Thanks for your valuable feedback
THANKU SO MUCH
Most welcome🙏
I was trying to figure this out for a while and you made it so quick and easy. Thank you!!
Very helpful!
Thanks for your valuable feedback
Merci de partager vos connaissances. Bravo
Merci d'avoir regardé et partagé vos précieux commentaires.
great thanks a lot Mr
Thanks for your valuable feedback.
nice 👍🏻👍🏻👍🏻👍🏻
Thanks for your valuable feedback
مرسی
Thank you!
Awesome
Thanks for your valuable feedback
Great..PK, always found new way to do the work..it pleasure to work with you. Regards - Varun
Thanks Varun for nice words.
Thank you
Thanks for watching
Mr. PK your presentation is really excellent. I learnt some tricks from your excel videos. How can I take up Table_array for Vlookup from another worksheet? If you have any other video pl mention the link.
what should i do if i want to find AHT inspite of call .. kindyl please tell
in Google Calcs how it would be ?
Sir why don't you make vedeos in hindi language also
I think that will be very helpful for those who do not understand English language.
Why in my comput the comma must change to \ .. So the formula can work normaly
FORMULA IS WORKING BUT NOT GETTING THE EXECT VALUE,, EVEN I AM SELECTING 0 OR FALSE AT THE END OF THE FORMULA
Alternative in google sheets:
ruclips.net/video/0B9cc7shvoI/видео.html
How to u lookup in revarse lookup
I PK thanks for all your help and sharing these videos ...Pk I need you're help I want to calculate headcount required on a given day...I have aht, work type, and shrinkage % .do you have any tutorial for this. I will be very thankful for all your help on this
Sure Amol,
I will definitely try to make such video soon.
thanks pk
please upload a vedio on condition like if weight is 1 kg, amout would charge 50 rs. on every additional 500 grm weight 30 rs. extra charged. how we'll calculate this in excel
Sure Saurabh,
I will try to create such video. Thanks for the advice.
what does the array {1,2} mean or do here ..pleas explain .. .
Hi,
Array is changing the sequence of ranges virtually.
it won't work on another work sheet
You have to open up the functions argument and put "choose...." inside the "table_array" spot.
why did you put 2 in col_ind_num? 03:10
Result column
why don't you use XLOOKUP? it is very simple.
Not proper way to teach what is the mean of 1,2 after choose syntax? 👎️
Galat aya bhai not correct