Nice videos. Thanks a lot, I learnt a lot from your videos. I have a doubt, if we have large data and when we filter the data some rows goes hidden. I tried to vlookup, but error poping up, can you please post a video on this topic.
Hai,i have a file includes employee name and code.and I have got another file with employee names only . Is it possible to vlookup with name to get employee code.Kindly help
Tnx Mate :) We can set up.. same I will upload it soon👍 In sha allah.☺️ Am planning to create full fledged video on Sales, Purchase along with p/L & Inventory.. on that I will explain it🤝
Adyam search box undaku ennit data whole ayi click go to conditional formatting use the option the last click ennit select search box = data il 1st cell then delete the dollar sign format option click appol fill ennoru option und select colour then ok
Thanks a lot, the best in youtube. One doubt: is there a way to lookup a set of data/ like more than 4/5 columns together?Dragging one formula to other cells give answer NA.
hi Alfan..under vlookup if employee no is in column B and Name is in Column A..how to use the vlookup in this case keeping lookupvalue same as employee no..this is just example from your file, while in many formats we had come across this type of issue..
Sir your help to find look up one colom A captain SKUcolom B cantanin location same sku in different location how can get location sku location first colom, location 2 second colom location 3 third colom etc
Thanks Bro..Very valuable and useful video ..
Njan vlookaup padikkan kure video kandu..
Athil onnukoode manasilyath chettande video thanne...
Thank you so much sir❤️👍
Nicely demonstrated and very easy to understand. Thank you.
Thanks a ton😊
I am using vlookup function, very useful and multi purpose in excel ever I seen function
😊
Thanks Bro I am watching your videos one by one, its really helpful
😇
Nice videos. Thanks a lot, I learnt a lot from your videos.
I have a doubt, if we have large data and when we filter the data some rows goes hidden. I tried to vlookup, but error poping up, can you please post a video on this topic.
This video was really useful.. thank you so much ✨😇
😻
This video very usefull ,Thank u sir ❤😍
The best XL tutorial i ever seen, keep it up
Glad you think so! :)
Thanks brother . Good presentation.
Thanks for your feedback and I'm glad it helped 😊
You can download file used in the video : www.rowscolumns.com/free-excel-templates
Hai,i have a file includes employee name and code.and I have got another file with employee names only . Is it possible to vlookup with name to get employee code.Kindly help
Nice video bro, very much informative.
good presentation...very helpful
♥️
Thank you sir.
Super.
very useful
😊
Very useful video ❤❤
Glad to hear that
Informative video
Its helpful for the students
very helpful
thank you dear sir
😇
Thanks Alfan sir. How to set a searchable drop down list?
Tnx Mate :) We can set up.. same I will upload it soon👍 In sha allah.☺️ Am planning to create full fledged video on Sales, Purchase along with p/L & Inventory.. on that I will explain it🤝
@@rows_columns thanks , im waiting. How to create a form without VB?
@@remo89sr I will upload the same in coming week👍
Very useful😍
Hi Alfan- ഒരു searchable drop down list ഉണ്ടാക്കുന്ന method പറഞ്ഞുതരുമോ
Sure... Very soon I will upload the video and share with you🙂👍
@@rows_columns Thank you
Adyam search box undaku ennit data whole ayi click go to conditional formatting use the option the last click ennit select search box = data il 1st cell then delete the dollar sign format option click appol fill ennoru option und select colour then ok
In comparison for me only two data getting displayed remaining it shows Nil may i know the reason
Thanks bro
നമുക് name vlook ഇട്ട ശേഷം location വീണ്ടും vlookup ഇടാതെ copy paste chayyathelle annit cell number മാറ്റിയാൽ പോരെ
Great sir
Sir in the 1st case for finding the location, its against is name, so how can we select the empl number? I didnt understand
Thank you so much
You're most welcome
Thank you so much
Thanks a lot, the best in youtube.
One doubt: is there a way to lookup a set of data/ like more than 4/5 columns together?Dragging one formula to other cells give answer NA.
Thanks😊
Apply absolutely reference & try✌️
@@rows_columns yes that works🙏🏻
@@karthikavarma8970 💫👍😊
Apply Absolute reference by pressing F4
V look up formula type cheyumpol Enthanu range look up ennu last kanikunnath
3:15 Sir 0 ഇട്ടാലും കുഴപ്പമില്ല എന്ന് പറഞ്ഞില്ലേ. Zero use ചെയ്യുന്നത് എന്തിനാണ് എന്ന് പറഞ്ഞു തരുമോ?
Thanks😊
Welcome 😊
Exact എന്തിനാണ് 0 അല്ലെങ്കിൽ false കൊടുക്കുന്നത്
It will treat anything equal to zero (0) as false, anything unequal to zero as true.
Please share exel sheet
Thank you
Thank you!
Thanks for your feedback and I'm glad it helped 😊
You can download file used in the video : www.rowscolumns.com/free-excel-templates
താങ്കളുടെ നമ്പർ തരുമോ sir കുറച്ച് സംശയങ്ങൾ ഉണ്ട് ബുദ്ധിമുട്ടില്ലങ്കിൽ മതിട്ടോ
@@sharkwhale1402 send me ur contact details to alfankp86@gmail.com
ഓക്കേ sir
Please send spreadsheet
💯💯
hi Alfan..under vlookup if employee no is in column B and Name is in Column A..how to use the vlookup in this case keeping lookupvalue same as employee no..this is just example from your file, while in many formats we had come across this type of issue..
Hi Kiran, That case we can use either X Look up or Index Match... will share the link soon once I make the video😊
@@rows_columns noted with thanks
🙂🙂
🙏🏻👍👍
Can you send me an excel sheet?
Sir your help to find look up one colom A captain SKUcolom B cantanin location same sku in different location how can get location sku location first colom, location 2 second colom location 3 third colom etc
Pls give Watsapp no.
@@mohammediqbal2473 9746637500
📌To Learn Microsoft Excel in English, Click on the Below Link:
th-cam.com/video/Cn3-bLDkGMY/w-d-xo.html
Thank you so much brother
Thank you so much sir
Appreciate your positive feedback! Thrilled to hear you liked the video. Keep enjoying and stay tuned for more!😊