vlookup වලින් වැඩ කරන්නෙ කොහොමද? | Microsoft Excel Sinhala Tutorials - 17

#excelsinhala #vlookup #exceltutorials
Microsoft Excel වල වැඩ ඉතා පහසුවෙන් ඉක්මනට කරගන්න අවශ්ය නම් ඔයාල දැනගන්නම ඕන formula එකක් තමයි vlookup කියන්නෙ.
Tutorial එක සම්පූර්ණයෙන්ම බලල හරි විදියට vlookup formula එකත් එක්ක වැඩ කරන හැටි ඔයාලත් ඉගෙන ගන්න...
How to use vlookup formula in Ms Excel?
This tutorial shows how to use vlookup formula with practical examples.
මේ වීඩියෝ එක බලල ඔයාලගෙ ප්‍රශ්න, යෝජනා, චෝදනා ඔය ඕනෑම එකක් comment section එකේ comment කරන්න.
අපේ channel එකට subscribe කරන්නත් අමතක කරන්න එපා
ඔයාල දකින්න ඇති අපේ Video වල සමහර තැන් English වලිනුත් Explain කරල තියනව. ඒ මොකද English තමයි අනාගතය, ඔයාලට ලෝකෙට යන්න English අවශ්‍යමයි. අපේ ඕනෑම Video එකක් බැලුවාම ඔයාලට ඒ Topic එකට අදාලව තියන English words ටිකත් දැනගන්න පුලුවන්. ඉතින් එතකොට වැඩ දෙකක් එකම වෙලාවෙ සිද්ධ වෙනවා, ඔයාලට අලුතින් දැනුම ලැබෙනවා වගේම ඔයාලගෙ ඉංග්‍රීසි දැනුමත් වර්ධනය වෙනවා...
If you have any comments, suggestions for our videos, please mention them in the comment section. We highly value your feedback!
Like and Share our videos and don't forget to SUBSCRIBE to our channel!
අපේ Facebook Page එකට Like කරන්න
/ simplifyx.net
LIKE our Facebook Page!
/ simplifyx.net
අපේ website එක Visit කරන්න
simplifyx.net/
Visit our website :
simplifyx.net/ Please Like and Share this video!
Don't forget to subscribe to our channel!

[@asitharanatunga8858]

Excellent presentation. Thank you very much

[@tilinanirmal]

tnx. Explained very clearly ! Good understanding

[@harshasamanpriya4218]

Supiri... marama widiyata pehedili oya kiyala dena dewal.. all the best..

[@PalithaAlahakoonDAP]

superb. good job very simple explanation.

[@tiptronicsrilanka7140]

Very clear and simple - Thanks for your support

[@hirunikaveeshaabeysinghe8482]

Thank you very much for your great effort. It's highly appreciated.👍👍

[@asankaruchiran8314]

It's greatly helpful. Thank you.

[@umlkandana5248]

Supar niyamai eththatama godak dewal egena gaththa thx oyata mewage dewal idiriyatath karanna wasanawa shakthiya dhairiya lebewa (budu saranai)

[@mohamedshazrin701]

Useful One. Thank You

[@bhagyasandamali7861]

This was really helpful . Thanks a lot

[@rusirunadeeshan4581]

Thank You, Nice Lesson 😘👌👍

[@kasunasiri]

Great work brother .. thank you..

[@sithuminijayasekara4782]

thank you so much very valuable one

[@funkylivili]

Thank you very much. Nicely explained

[@matheeshasathsara3792]

It's grateful thank you !❤️

[@prabath4054]

ස්තූතියි sir niyamatma theruna.

[@anushiekanayaka9917]

Really appreciate your effort and a quality stuff! If u can just share the document with data that u r working it will be awesome!

[@sajithchamara175]

Great help obviously ❤

[@vasanthahettiarachchi4311]

Thank you so much for the easy to understand explanations.

[@dayanandarathnayaka3481]

Thanks for teaching.

[@hasithaisuranga3821]

බොහොම ස්තුතිය ❤

[@buddhikaperera5716]

wonderful lesson. thanks

[@ayeshasewwandi3638]

Great work❤❤

[@gemunugunawardhana8893]

Wow ❤️❤️ thank you

[@Danuka_Malinga]

Great , thank you

[@buddhivarunasenarathne5242]

I was expecting the same from a Sri Lankan to do for a long time. keep up this good work best of luck!

[@SimplifyX]

thanks a lot for the appreciation. means a lot!

[@nishanthajayasinghe5281]

Excellent

[@wageeshajayalath3807]

Thank you very much !!!

[@sanjeewakrishantha1113]

great work 💋
.....

[@lankanimadusha7305]

Highly appreciate

[@dinushashammi4952]

Thank you ...............so much...................

[@indikapushpakumara346]

Thank you very much & I'd be glad if you could attach herewith the datasheet

[@himshiisha1772]

This was really helpful. Thanks alot. This was the easiest video to learn. 🥺🙌❤️

[@SimplifyX]

thanks a lot for watching

[@kasunjayaweera2367]

Index match video ekak thiynawada. Oyage lesson maara clear. Thanks

[@presantha1]

patta ..

[@ransilankaoffsetdigitalpri3639]

Tks Bro... we expect more..

[@SimplifyX]

Sure 👍 thanks a lot for watching

[@sujaninisansala797]

Good channel ...keep it up bro

[@SimplifyX]

Thanks a lot!

[@sanjeewapradeep500]

Ela

[@ireshapriyadharshanijayath7720]

ස්තුතියි . ගොඩක් වටී

[@SimplifyX]

Thank you very much

[@dilupadinithi5243]

Thank you 🙏

[@asela4135]

thank you dear

[@vishwadananjaya8815]

I passed CA It exam after watching this videos thank you very much ❤ really apreciate you

[@lakshanisamarajeewa5678]

Thank you for sharing ur valuable knowledge with us ❤️👍

[@malithaalankulama]

Excellent lesson. thank you

[@SimplifyX]

You are most welcome. Thanks for watching our channel :)

[@dilinijayawardana4200]

Thank you

[@prasadimanjula210]

Thanks.

[@thakshilafernando228]

Lassana voice ekak

[@yosithdissanayake1385]

great .thnkyou❤

[@SimplifyX]

You're welcome 😊 Keep watching us

[@isharadinuth6669]

Excellent...

[@SimplifyX]

Thanks a lot

[@warunat]

Simple & Excellent

[@SimplifyX]

Thank you very much

[@sandunjayasekara1839]

lookup value eka sinhalaen thiyenakota #N/A error eka enawani.. solution ekak kiyanna puluwanda ? lookup value number ekak demmama hariyata function eka weda

[@SL_MusicHub]

thank you

[@chethakanandun4975]

❤️❤️❤️

[@hansikaperera8360]

True danne dala watinakamak denna da? Ethakota false danne harima agaya dannada? Mata Chuttak true and false explain karannako 🙏🙏🙏

[@ajithjayasekara7530]

Good job, please do the stock management formula also. Thank you... Keep it up,

[@SimplifyX]

Yes will do for sure. Thanks a lot

[@desertfrog-nimal]

Yes please do. thank you

[@user-ys8rd5tf7z]

Thanks

[@shehalfernando]

Meke colour wenne , number ekak dunnoth witarai .word ekak vlookup karala aran dunnama colour wen nane (fill effect eken)? Number ekak dipu nisai color une.word ekak match karama wen natte ai?plz give me solution.thanks

[@salukisamindika622]

පුළුවන් නම් formulas ඔක්කොම මෙහෙම explain කරනවද

[@nelukadkalukeerthi8072]

2021 VERTION EKE VLOOKUP ME WIDIYATA GNN BANE DEA RIBBEN EKA WENSNE

[@dealzzblast5489]

Please give this demo data set also

[@DineshikaJayarathna]

Very clear tank you

[@SimplifyX]

You are most welcome. Thanks for watching our channel :)

[@samuddhipunchihewa9998]

Thank you so much for uploading this. It is easy to understand.

[@SimplifyX]

Thanks a lot for the compliment. Keep watching our channel

[@janithherath8409]

useful

[@SimplifyX]

Thanks for watching our channel :)

[@bhagyanishani4543]

Thank you.

[@SimplifyX]

You're welcome! Thanks for watching

[@sachinihansika2757]

❤️

[@Kidsbabyinrashmi23]

Aiya microsoft excel eke certificate ekak ganna thanak nadda

[@lavtc-office2714]

merge කරපු Row කොහොමද VLOOKUP කරන්නේ කියල කියලා දෙන්න පුහුණුවන්ද සර්

[@nilmishamilki9014]

Great job .😊

[@SimplifyX]

You are most welcome. Thanks for watching our channel :)

[@slchami300]

@@SimplifyX please give sample file to the learners to practice what you tutored. i appreciate your work

[@anon2817]

Nam ekka table ekka select krta answer enwa neda

[@samithjayasinghe4230]

1:30 pm-12:30am= 1:00:00pm waradi ne.. ai kiyala kiyanna ko...

[@Harsha_Kunkuma]

supiriiiii

[@SimplifyX]

Thank you so much! Appreciate it :)

[@harshanitharaka6968]

Deta sheet link karana vidio akak.danna puluwanda

[@neviyasdiary]

Thank you very much...$ mark nathiva nannaththara vela hotiye 👍👍

[@SimplifyX]

You are welcome

[@hansikaperera8360]

HLook up gannath videos krannakoo mula idalama

[@uvindubandara7358]

Advanced ekk krnko

[@wordbeauty7571]

Mama podi shop ekak krnwa eke stock eka excel sheet eke thiyenne,invoice ekath excel hadala thiyenne invoice eka daddi stock eken quntity adu wena widiyta hdanne kohomada plzz help

[@SimplifyX]

අනිවාර්‍යෙන් මේ ගැන විස්තරාත්මක වීඩියෝ එකක් කරනව ඉස්සරහට

[@desertfrog-nimal]

⁣ගොඩක් දෙනෙක්ට වටිනව එහෙම එකක්

[@mrknown1405]

මෙ වගේ demo data set එකක් ගන්නෙ කොහොමද අපිට පුරුදුවෙන්න

[@hasanthilakshaninawarathna4158]

Ou ane kohomd

[@dishan.sanjaya24]

Thanks bro

[@auperera9140]

V lookup / code eka mokakda

[@SimplifyX]

පැහැදිලි මදි ප්‍රශ්නෙ

[@debaraadrian3445]

Excle wla adu krnne khmd ganan

[@SimplifyX]

Me playlist eke මුල හරියෙ තියන වීඩියෝ බලන්න

[@udayaherath1074]

Matanam monawath therune na

[@desertfrog-nimal]

මුලින්ම තියෙන සිම්පල් වීඩියෝස් එකින් එක follow කරගෙන ආවොත් තේරුම් ගන්න පුලුවන් වෙයි

[@prabath4054]

ස්තූතියි sir niyamatma theruna.

[@dilshanmalith8995]

Thank you

[@geethshashiranga5473]

Thank you

[@channapaluvila970]

Thank you

[@SimplifyX]

You're welcome