Vlookup with Multiple Criteria in Excel in Tamil
ฝัง
- เผยแพร่เมื่อ 14 ก.พ. 2022
- How to Create Vlookup Function with Multiple Criteria in Excel Step by step Tutorial.
Practice File: docs.google.com/spreadsheets/...
Click the Link below to learn. (Subscribe for more upcoming Tutorials)
Cell Reference in Excel in Tamil
• Cell Reference in Exce...
Vlookup between two Workbooks in Excel in Tamil
• Vlookup between two Wo...
VLOOKUP in Excel in Tamil
• VLOOKUP in Excel in Tamil
#exceltutorialtamil #endlessknowledge
Don’t Forget to Follow:
twitter.com/EndlessKnowled1
facebook.com/enlessknowledge
instagram.com/end_less_knowledge
Really good. Thank you for the practice file.
your teaching is really awesome, which helped me in finding out an error and rectified myself..Hats off Bro!!
This video has created some sparks in me and made me to have more confident to work on excel with different criteria without any hesitation.
Glad to hear that brother... Keep learning more about Excel th-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
All your videos are very good.
I have one question here.
In production company many styles are produced in different lines.
In reports, we are entering stylewise.
Suppose in any case, in a particular given date, if we need all styles produced means how to get the report.
Simply how to convert stylewise into date wise.
A style runs to 1 or 2weeks.
பெரிய மனசு sir உங்களுக்கு தெரியாதவர்களுக்கு share பன்னுங்கன்னு சொல்றது.. சூப்பர் ....
Yes, everyone deserves to know everything...
@@EndlessKnowledge Endless Knowledge for Endless People
Super video very detailed
ஐயா, விண்டோஸ் எக்ஸ் எல்7ல் பத்து அடிமான முறையை 12 அடிமானம் முறையாக மாற்றும் முறை சொல்லுங்கள்.
Super bro really useful thank you
Really thank you soo much bro
Appreciated sir
Superb, I like very much for your teaching method, kept it up
thanks, i will... Keep watching more videos...
Love you always sir... Your explanation was ulti....
Thanks a ton...
Sir I have same issue with my work a cell having multiple characters i need to lookup for the agents name but if i do vloop i don't get the output for those cells have multiple character and thetr solution for that and its time consuming work please help me sir
yes, explanation is too good, it did spark off , still need to practice . any chance of one to one, just to ensure what iam doing is right?
Thanks Bro. vlookup almost dead with xlookup. Due to compatibility issue still vlookup alive
Hai sir excel irukura all database format Ellathaiyum word la eapdi print or work eapdi pannurathu pls sollunga sir
Super Sir Really Use full 👌
glad it was useful to you...
sir clear my problem i want more results in different cells from that particular look up value like 2 or more results from each region but name is one only.
Tnx...
thank you sir
Useful video anna 👌🙏
glad it was useful to you nanba...
Thank you
Broo...ithuku instead of match and vlookup use pannalam...I tried with Index and match also...after watching ur tutorials....Index and match so powerful 😁😁😁😁
lot of ways are there nanba...Great 👍
@@EndlessKnowledge ❣❣❣
How to calculate last three month or five month trends in report?. Thanks
Super BRO 👌
Thanks nanba... keep watching my friend...
வணக்கம் அய்யா... நான் உங்களுடைய எக்செல் விடியோ பார்த்து வருகிறேன்.. நான் coop auditor aga உள்ளேன்.. எனக்கு audit reports ஐ Excel use பண்ணி நானே ready pananum nu oru aim..(computer centre la kodukamal). So எனக்கு கொஞ்சம் ideas koduThu உதவ முடியுமா...?
Hi bro please upload multiple excel sheet making a chart example (total sales, Delivery sales,Counter sales,wastage,sales average) by using all to make chart thank you
Will upload soon my friend...
Suprp..👍
thanks ...
Sir why should they have a helper column?
well teaching
Thanks...
Bro enaku oru doubt nambadan helperla name region sethu kanupidichachu apram yen taniya formula podanum
Bro, can you please share about Sumif and Vlookup Combination video
Bro, file to file data select formula explain pls
Sir deivam sir neenga
How to pick up if a salesman has saled different products in same region.Even though the salesman sold different products, I was shown only one and not more than that.
Arumai sir
We need learn formultiple certeria with particial text vlookup in excel
Vlookup neenga soldra mari than pandren bt work aga matithu konja eppadi pandrathu sollunga bro
How to get sample data for practise
SIR PLEASE DO THIS SAME LOGIC AT NEXT SHEET( AFTER I SAW YOUR VIDEO I GO TO INTERVIEW) BUT AVANGA COMBINE PANATHA NEXT SHEET LA PODU VLOOKUP PANI KODUVARA SOLURAGA I WAS STRUGGLE TO DO PLS HELP ME AND POST THE DOUGHT.
PO tracker video poduga Bro
Bro update full Excel course one video to learn
HOW TO MAKE THE RIGHT SIDE BLUE TABLE WHERE YOU USE FORMULA PLS PUT AN TUTORIAL ON THAT.
index match use panna time save agum bro
Hi bro
Please tell
If and if error with vlookup condition
hey nanba... watch this th-cam.com/video/W6M-SipvTTQ/w-d-xo.html
Thanks
Welcome... Keep learning more about Excel th-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
I am from Karnataka,don't know Tamil.My son talks fluent. But your sweet pronunciation is make undurstant me sir.
Bro Recipe Multiple Results Ebdi Therinjika﹖
e.g. Wheat Flour 0.215g+Oil 0.03ml=Chapathi 6Nos Per Head (Result Manually Already Inserted),
48 Head Ku Result﹣A Mattum Maathura Function Enna
Adhu pathi Oru video podunga Plz
Regionla yalla totalum yan varala
South region apdina
South regionla ulla yalla totalum yan total aagala
Sir f 4 kudatha lock angamatuthu sir
@8.05 HOW TO INSERT DROP DOWN BUTTON AND SELECT MULTIPLE NAME IN SINGLE CELL
Vlookup formula la mistakes katithu brother i can't find the error
Anna pls make video automatic ✓ mark, once double click enable tick mark Again double click uncheck the tick mark option
have you watched this nanba...th-cam.com/video/AJy__dbn0Fc/w-d-xo.html
Why no reference to Pivot table usage?
several way are there my friend like you said Pivot Table, Index match, Vlookup choose and even xlookup... i tried to make it short that's it nanba...
Enaku - la results varudhu y anna?
Anna
Please upload Excel Power Query
soon nanba...
i didnt get ans bro dont know y
Sir wilcome software padhi therichikanum aasa sir adha padhi solla mudiuma sir
will try that soon...
@@EndlessKnowledge thanks sir 🥲.....I hope you do 💯
1st view 1st comment 1st like
Ungalukku naan first like 😜
@@RamKumar-gs3tz ungaluku na 1st like and firest comment
🎉
Sir pls context no sir one doubt sir pls
Excel online course sollitharingla
When We are selecting the look up value , why can't we select the helper desk column alone ?why are you using again those concatenate all those things bro
nanba could you mention those timestamps?
I'm also have same question. Sir Pls explain briefly, that why not using helper clmn
Sir,
I have a doubt,
I would like to change months name.
But right now
I have
January
February
March
4
5
6
7
8
9
10
11
12.
I DON'T KNOW how to change it,
Kindly assist me,
Regards
Velu
My friend you can use =TEXT(DATE(2022,A1,1),"MMMM") and In this formula "A1" is the reference to the cell containing the month value you want to convert
எங்க ப்ரோ helper coulm அதைத்தான் hide பன்னிங்க items coulm எங்க ப்ரோ
Minus
Anna these video I can't understand is too hard
Thank you sir
your most welcome...