How to Use the VLOOKUP Function in Excel (Step by Step)

Тәжірибелік нұсқаулар және стиль

This video tutorial offers a detailed description of how to use VLOOKUP in Excel. This function works like a phone book. Based on the information you know Excel will look up the details you don’t know and need to find out in a data table. If you’re curious how to use VLOOKUP, let’s go through it, step by step, together!
Watch next video tutorial:
How to Compare Two Columns in Excel to Find Differences (The Easiest Way)
► • How to Compare Two Col...
Most popular Excel Functions
► • How to Calculate Diffe...
================
❤️ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron
KZread ► www.youtube.com/@ExcelTutoria...
================
⏱️Timestamps⏱️
0:00 How to Use the VLOOKUP Function in Excel
1:00 The VLOOKUP function - The Details Needed to To Make the Function Work
2:43 The Last Part of the Formula - True or False Function
3:13 The Examples of How the VLOOKUP Function Works in Excel
================
Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers! :)
► kzread.info...
Transcription How to Use the VLOOKUP Function in Excel (Step by Step)
► www.easyclickacademy.com/how-...
Got Microsoft Office 365? Get it here
► www.easyclickacademy.com/buy-...
Connect:
LinkedIn ► / easyclickacademy
Facebook ► / easyclickacademy
Screen Recorder & Video Editor:
Camtasia ► techsmith.pxf.io/c/1266206/34...
#MicrosoftExcelTutorial #ExcelQuickAndEasy #EasyClickAcademy

Пікірлер: 29

  • @Zecodesignz
    @Zecodesignz20 күн бұрын

    Finally found the video I was looking for 😅😅 Take your flowers 🌺🌹

  • @ExcelEssentials_
    @ExcelEssentials_9 ай бұрын

    Important tip: when you have a spreadsheet with a lot of columns: just make sure that the column with the lookup value is simply left of the column you want to search in. The Vlookup function can only search to the right! Good luck 😊

  • @ahwaheed2002
    @ahwaheed20022 ай бұрын

    More helpful, The only video i understood this topic with it.

  • @Scie820
    @Scie8204 ай бұрын

    Well explained. Much appreciations 🎉

  • @nigelraphe
    @nigelraphe23 күн бұрын

    Great Explanation

  • @agostinhoinocencio7013
    @agostinhoinocencio70132 жыл бұрын

    I don't know what to say, thank you so much.

  • @kamarasiakarifa6359
    @kamarasiakarifa63597 ай бұрын

    Thanks very much,well understood.

  • @asimsiddiq475
    @asimsiddiq4752 жыл бұрын

    Thanks a lot, at your every step.

  • @user-gj5cl9wj7y
    @user-gj5cl9wj7y9 ай бұрын

    This really helped a lot

  • @TheHoshmanddeeba
    @TheHoshmanddeeba4 жыл бұрын

    VERY NICE, loved the method of explaining..

  • @ExcelTutorialsEasyClickAcademy

    @ExcelTutorialsEasyClickAcademy

    4 жыл бұрын

    You’re Welcome :)

  • @Zain-nx3cw
    @Zain-nx3cw7 ай бұрын

    thank you so much sister

  • @shortybabe9778
    @shortybabe977810 ай бұрын

    Thank you.

  • @aleksapivnicki5067
    @aleksapivnicki50672 жыл бұрын

    Thank you very much,this video really helped me!

  • @anurakumararanassingha9621
    @anurakumararanassingha962111 ай бұрын

    Thanks you

  • @aboodlifetv778
    @aboodlifetv7786 ай бұрын

    Thanks

  • @prabhakarraokaranam719
    @prabhakarraokaranam7193 жыл бұрын

    Hi .. Very nice .. I want to display both names like last name and first name when I give empno how to do?

  • @sharada2386
    @sharada2386 Жыл бұрын

    Nice...

  • @ricajoypongan460
    @ricajoypongan4602 жыл бұрын

    more tutorial please

  • @chamthkawsalya456
    @chamthkawsalya456 Жыл бұрын

    ගොඩක් හොදයි😊❤

  • @kgururprasadbhat5442
    @kgururprasadbhat54423 жыл бұрын

    Mam, I need a formula for slabwise payment for insurance, suppose blow 30 age people has to pay rs.1000, if age between 30 to 50 2000, how to calculate

  • @baseer4371
    @baseer43714 жыл бұрын

    Hi there 👋..now please create video index , match.. best one thanks

  • @ExcelTutorialsEasyClickAcademy

    @ExcelTutorialsEasyClickAcademy

    4 жыл бұрын

    Bas thank you for your tip :)

  • @kafiahmed4930
    @kafiahmed49309 ай бұрын

    please make a video on sumifs function

  • @ExcelTutorialsEasyClickAcademy

    @ExcelTutorialsEasyClickAcademy

    9 ай бұрын

    Here you are: How to Use SUMIF Function in Excel (Step by Step) kzread.info/dash/bejne/eqeZppSsgq2yldI.html

  • @sadmantonmoy2458
    @sadmantonmoy24584 жыл бұрын

    Pleaae give tutorial of XLookup

  • @ExcelTutorialsEasyClickAcademy

    @ExcelTutorialsEasyClickAcademy

    4 жыл бұрын

    Sadman, thank you for your tip :)

  • @martinz6131
    @martinz61313 ай бұрын

    This doesnt work for me

  • @martinz6131
    @martinz61313 ай бұрын

    it doesnt work with , but with ; ... why the fk is this

Келесі