Excel VLOOKUP Exact Match: Sinhala ▶ Excel Advanced Formulas and Functions - Episode 01(Sinhalen)

⬇ 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

[@dhanukadissanayaka3064]

ඉතාමත් හොද පැහැදිලි කිරීමක්. පාඩමේ මුල් කොටස ඉතාමත් වටිනවා. ගොඩක් වීඩියෝ බලලා මේකෙන් හරියටම ඉගෙනගත්තා.

[@ExcelandPowerBISinhalen]

Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html

[@bhasha8060]

Ammoo patta mage bokka niyama wadak ada tamai hambune channel eka 😘😘😘😘

[@imransahabdeen508]

bro u taught like a pro to the point. supiri

[@danushkakarunarathna6058]

Thanks bro.. very good explanation and always teach with keyboard keys to learn eazy and smart way..👍👍👍👍❤

[@ExcelandPowerBISinhalen]

Thankks Danushka😍

[@virajlakshanrathnayake279]

Good job brother 👍👌 තිතට කියලා දෙනවා, නියම ගුරෙක්.. 👌👏

[@ExcelandPowerBISinhalen]

Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html

[@SulariRanasinghe]

Thank you for teaching us how to use V LOOK UP function correctly .

[@janakasandunbandara9461]

Supiri video eka bro niyametama therenawa thank you very much

[@ExcelandPowerBISinhalen]

Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html

[@sudesh9124]

Excellent. Finally I found what I was looking for. Thank you....

[@ExcelandPowerBISinhalen]

Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html

[@nalingunawardana1591]

Good one ...

[@movindumayadunna]

Thank you very much! Helped me in a very critical situation. Thanks again❤️

[@rifniahamed6231]

Good work bro!! Very clear and highly informative 👍👍

[@ExcelandPowerBISinhalen]

Thank you Rifni Ahmed. Appreciate

[@rifniahamed6231]

@@ExcelandPowerBISinhalen Best of luck and please do share more videos 👍☺️

[@dealzzblast5489]

Thawa vlookup videos genna

[@janaka19801]

Excellent explanation. So thanks

[@dileshkumara644]

Wow! good explain and good sound quality. Please continue this lesson serious and it help to more peoples.

[@ExcelandPowerBISinhalen]

Thank you very much Dilesh. We will update new videos very soon.

[@tinuranz1053]

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

[@buddhikamadushanka19]

Thanks.... good job

[@hansikaperera8360]

HLOOK UP gannath Mula idan kiyala dennako... If function ekath kiyala dena videos karannako..

[@arunanuwanchandrasiri4259]

Keep it brother

[@hasitheranga3]

Good lesson and good teaching.all the best!

[@ExcelandPowerBISinhalen]

Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html

[@hasithapramodya4270]

Thank you! Clearly explain 🤟

[@ruvinimadushani2960]

Thank you..👍

[@kavindudayananda7833]

Thank you very much

[@yamunakumari1067]

Thank you so much..💗👍👍

[@SachithAndSachini]

වටිනවා

[@mohamedzarook287]

Hi . Can you make a vedio how to use Vlookup in a Apple Mac . It will be great. Thank You

[@ashanksvishka500]

Thanq brother

[@upekshikajayaratne3165]

Thank you so much to this explained. Thank you ❤

[@ExcelandPowerBISinhalen]

Thank you very much Upekshika, this made my day 😍. Be with us and help us to grow we will upload new videos soon.

[@upekshikajayaratne3165]

Yes sure. Go ahead. Its realy valuable. ❤
Name is Upekshika 😐

[@anon2817]

කොලොම් Index widhta ganna one ape table eke eka tinne wi wani කොලම් eke kilda. Ntm excell sheet eke kiwani කොලොම් eke kilda?

[@dealzzblast5489]

Tnx❤️ data sheet ekath dunnata 🔥

[@heshteach8212]

Godaak hodata wisthara karanawa... Thank You so much brother.

[@ExcelandPowerBISinhalen]

Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html

[@gayandesilva3180]

Thank you

[@donenew3438]

very nice ..

[@dealzzblast5489]

වටිනවා godak data sheet ekath denna puluwan nam thawa watinawa practice karannath ekkama

[@chianthanafernando7961]

Well explained. Thanks a lot !!!

[@ExcelandPowerBISinhalen]

Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html

[@rohaninduka1039]

thanks in deed

[@ExcelandPowerBISinhalen]

Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html

[@kasunmanchanayake5550]

Aluthma video eka awith balanna indexmatch

[@kamalkasandamini9578]

Superb❤

[@madhushisewwandi623]

1K like from me 👍

[@sithijakaveen5989]

Thank you bruh!🖤

[@warunat]

thanks ,its great

[@ExcelandPowerBISinhalen]

Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html

[@sardhamahimi4459]

Wow..... it very clear...

[@laalumalli5471]

Super 👌❤️

[@ExcelandPowerBISinhalen]

Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html

[@dilshanidilhara2188]

thank You..

[@akilakanchana6189]

bro kalin padm tika gnna wdyk ndda,,,hoyaganna bene
me video eka supiri. wde goda

[@ajithpriyachandana89]

Thanks

[@m.m1004]

Thanks bro

[@subashinibulathsinhala469]

හරිම හොදයි හොදට කියලා දෙන්වා, ආසාවෙන් අහන්න ඉන්න පුලුවන් 👍

[@nadeekapiyumali5996]

Range eka locke karanna khomada

[@wasanarajawasan2824]

Thank youuuuu

[@dinelkanadeeshani8728]

Attendance sheet එකක category එක දුන්නම ඒ category එකට අදාල සේවකයන්ගෙන් නම, EPF NO auto update වෙන්න හදන්න පුළුවන්ද copy paste නොකර. (Drop down list එකක category එක දෙද්දි ඒකට අදාල නම් ටික පෙන්නන්න)

[@ExcelandPowerBISinhalen]

Yes we will do a video on that.

[@dilinilakshika8034]

Client payment list ekakin. Ekama clientge payment 2k thibunoth e payment 2ma vlookup walin select karaganna barida

[@ExcelandPowerBISinhalen]

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!

[@hansikaperera8360]

IF FUNCTION oni basic to advanced Mula idan kiyala dennako

[@ExcelandPowerBISinhalen]

Ape IF function video eka balanna czcams.com/video/DylFt_F-bC4/video.html

[@achalapriyadarshana874]

❤️

[@debaraadrian3445]

Thava video ek danna vlookup

[@inspire2.045]

😍😍

[@lithikaratnayake9236]

Conditional format ගැන video එකක් කරන්න පුලුවන්ද?

[@ExcelandPowerBISinhalen]

Sure will do in the futre. Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html

[@chamara7683]

මට දැනගන්න ඕනෙ excel fill දෙකක vlookup කරන්නෙ කොහොමද ???

[@ExcelandPowerBISinhalen]

Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html

[@kasunlakshitha8370]

💯❤‍🔥

[@amsinstitute3121]

oya gif animation karanawad ?

[@ExcelandPowerBISinhalen]

No.

[@hansikaperera8360]

Vlook up value kiyanne mokakda??

[@ExcelandPowerBISinhalen]

Thank you very much. අපගේ නවතම වීඩියෝව නරඹන්න. czcams.com/video/ngBcejEvU5A/video.html

[@disnakumari8934]

Akuru pahadeli ne

[@priyanthapathiranage9510]

මට ඇති ගැටළු නිරාකරණය කර ගැනීමට දුරකථන අංකය දෙන්න හැකිද? [e-mail]

[@channeldl143]

Thank you so much

[@travelayale2616]

THANKS BRO