Excel VLOOKUP Exact Match: Sinhala ▶ Excel Advanced Formulas and Functions - Episode 01(Sinhalen)
Vložit
- čas přidán 7. 09. 2024
- ⬇ Download Workfile from here: drive.google.c...
Excel VLOOKUP for Beginners. This article begins a series covering one of the most useful Excel functions - VLOOKUP. At the same time, it's one of the most intricate and least understood.
In this tutorial, I will try to explain the basics in a very plain language to make the learning curve for an inexperienced user as easy as possible. We will also explore some formula examples that cover the most common usages of VLOOKUP in Excel.
Excel VLOOKUP - basic description and syntax
VLOOKUP formula examples
How to do vlookup from another worksheet
How to vlookup from a different workbook
Using a named range or table in VLOOKUP formulas
VLOOKUP formulas with wildcard characters
Exact match vs. approximate match
Excel VLOOKUP - things to remember!
Vlookup Wizard for Excel - easy way to write complex formulas
Merge Tables Wizard - quick and easy alternative for Excel VLOOKUP
Learn Microsoft Excel and Microsoft Power BI in Sinhala with this group. We will be teaching Excel from Basic to Advance in a very simple form.
Other Important Videos
Excel VLOOKUP Exact Match: Sinhala ▶ Excel Advanced Formulas and Functions - Episode 01(Sinhalen)
• Excel VLOOKUP Exact Ma...
Amazing and Simple Data Entry Form Excel: Sinhala ▶ Excel Tips and Tricks - Episode 01 (Sinhalen)
• Amazing and Simple Dat...
Excel Top 30 Shortcut Keys : Sinhala ▶ Excel Basics - Episode 06 (Sinhalen)
• Excel Top 30 Shortcut ...
Excel Data Validation Controls : Sinhala ▶ Excel Basics - Episode 04(Sinhalen)
• Excel Data Validation ...
Excel Drop-down list: Sinhala ▶ Excel Basics - Episode 03(Sinhalen)
• Excel Drop-down list: ...
Excel Progress Circle Chart: Sinhala ▶ Charts and and Data Viz. in Excel - Episode 01(Sinhalen)
• Excel Progress Circle ...
excel tutorial
excel basic
excel advanced tutorials
excel tutorial sinhala
excel sinhala
excel vlookup sinhala
excel dashboard
excel formulas and functions
excel shortcut keys
excel basic for beginners
excel tricks
power BI tutorials for beginners
power bi tutorial
power bi dashboard
power bi tutorial advance
power bi dax
power query
Also you can connect with me on Below Channels.
FaceBook : www.facebook.c...
LinkedIn : / kasun-manchanayake-fmv...
Web : www.dubaipowerbi.com
We will be covering these areas from our excel and Power BI tutorials series.
My Online Courses
1. The Beginner's Guide to Excel - Excel Basics Tutorial
2. Advanced Excel Formulas and Functions (8 Hours)
3. Analyzing Data with Excel Power Query, Power Pivot and DAX (20 Hours)
4. Excel Data Visualization in Depth (5 Hours)
5. Excel PivotTables in Depth (5 Hours)
6. Analyzing and Visualizing Data with Microsoft Power BI (20 Hours)
7. Excel Master Class
8. Excel Dashbaords Course
8. Financial Reporting with Power BI
9. HR Analytics with Power BI
Text Functions
Logical Functions
Information Functions
Date and Time Functions
Lookup and Reference Functions
Math and Trig Functions
Statistical Functions
Database Functions
Financial Functions
Engineering Functions
Cube Functions
Web Functions
Excel Dashboards
INDEX + MATCH CONDITIONAL FORMATTING CONCATENATE VLOOKUP SUMIF, COUNTIF, AVERAGEIF IF STATEMENTS HLOOKUP XLOOKUP SUM, COUNT, AVERAGE PIVOT CHARTS DATA VALIDATION CONDITIONAL FORMATTING VBA MACRO DASHBOARDS DROPDOWNLIST
#exceltutorialsinhalen #excelvlookup #exceldashboard
ඉතාමත් හොද පැහැදිලි කිරීමක්. පාඩමේ මුල් කොටස ඉතාමත් වටිනවා. ගොඩක් වීඩියෝ බලලා මේකෙන් හරියටම ඉගෙනගත්තා.
Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html
Ammoo patta mage bokka niyama wadak ada tamai hambune channel eka 😘😘😘😘
bro u taught like a pro to the point. supiri
Thanks bro.. very good explanation and always teach with keyboard keys to learn eazy and smart way..👍👍👍👍❤
Thankks Danushka😍
Good job brother 👍👌 තිතට කියලා දෙනවා, නියම ගුරෙක්.. 👌👏
Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html
Thank you for teaching us how to use V LOOK UP function correctly .
Supiri video eka bro niyametama therenawa thank you very much
Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html
Excellent. Finally I found what I was looking for. Thank you....
Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html
Good one ...
Thank you very much! Helped me in a very critical situation. Thanks again❤️
Good work bro!! Very clear and highly informative 👍👍
Thank you Rifni Ahmed. Appreciate
@@ExcelandPowerBISinhalen Best of luck and please do share more videos 👍☺️
Thawa vlookup videos genna
Excellent explanation. So thanks
Wow! good explain and good sound quality. Please continue this lesson serious and it help to more peoples.
Thank you very much Dilesh. We will update new videos very soon.
I think you should better to participate a good english course or have to watch more english videos to improve your english knowledge .
Good explanation
Lesson series
It helps
People
Thanks.... good job
HLOOK UP gannath Mula idan kiyala dennako... If function ekath kiyala dena videos karannako..
Keep it brother
Good lesson and good teaching.all the best!
Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html
Thank you! Clearly explain 🤟
Thank you..👍
Thank you very much
Thank you so much..💗👍👍
වටිනවා
Hi . Can you make a vedio how to use Vlookup in a Apple Mac . It will be great. Thank You
Thanq brother
Thank you so much to this explained. Thank you ❤
Thank you very much Upekshika, this made my day 😍. Be with us and help us to grow we will upload new videos soon.
Yes sure. Go ahead. Its realy valuable. ❤
Name is Upekshika 😐
කොලොම් Index widhta ganna one ape table eke eka tinne wi wani කොලම් eke kilda. Ntm excell sheet eke kiwani කොලොම් eke kilda?
Tnx❤️ data sheet ekath dunnata 🔥
Godaak hodata wisthara karanawa... Thank You so much brother.
Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html
Thank you
very nice ..
වටිනවා godak data sheet ekath denna puluwan nam thawa watinawa practice karannath ekkama
Well explained. Thanks a lot !!!
Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html
thanks in deed
Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html
Aluthma video eka awith balanna indexmatch
Superb❤
1K like from me 👍
Thank you bruh!🖤
thanks ,its great
Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html
Wow..... it very clear...
Super 👌❤️
Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html
thank You..
bro kalin padm tika gnna wdyk ndda,,,hoyaganna bene
me video eka supiri. wde goda
Thanks
Thanks bro
හරිම හොදයි හොදට කියලා දෙන්වා, ආසාවෙන් අහන්න ඉන්න පුලුවන් 👍
Range eka locke karanna khomada
Thank youuuuu
Attendance sheet එකක category එක දුන්නම ඒ category එකට අදාල සේවකයන්ගෙන් නම, EPF NO auto update වෙන්න හදන්න පුළුවන්ද copy paste නොකර. (Drop down list එකක category එක දෙද්දි ඒකට අදාල නම් ටික පෙන්නන්න)
Yes we will do a video on that.
Client payment list ekakin. Ekama clientge payment 2k thibunoth e payment 2ma vlookup walin select karaganna barida
Hi Dilini Thanks for the Comment. VLOOKUP eken capture wenne first answer eka withrai. but oyata puluwan SUMIF kiyana function eka use karala payments dekema total eka ganna nathnam advanced VLOOKUP ekak use karanna puluwan lookup value ekata date field ekath ekathu karala karana widiyata.czcams.com/video/9APtjXEZzvs/video.html Man idiriye may sambandawa video ekak karannam. Thanks!
IF FUNCTION oni basic to advanced Mula idan kiyala dennako
Ape IF function video eka balanna czcams.com/video/DylFt_F-bC4/video.html
❤️
Thava video ek danna vlookup
😍😍
Conditional format ගැන video එකක් කරන්න පුලුවන්ද?
Sure will do in the futre. Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html
මට දැනගන්න ඕනෙ excel fill දෙකක vlookup කරන්නෙ කොහොමද ???
Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html
💯❤🔥
oya gif animation karanawad ?
No.
Vlook up value kiyanne mokakda??
Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html
Akuru pahadeli ne
මට ඇති ගැටළු නිරාකරණය කර ගැනීමට දුරකථන අංකය දෙන්න හැකිද? priyanthatsk@gmai.com
Thank you so much
THANKS BRO