Harry Viral
Harry Viral
  • 1 595
  • 2 377 488
Amazing VLOOKUP Formula with Lookup Value From Within Description
Welcome to our latest Excel tutorial! In this video, we dive deep into the powerful VLOOKUP formula and demonstrate how to extract lookup values from within a description. Whether you're a beginner or an experienced Excel user, this tutorial will enhance your data management skills and streamline your workflow.
📌 Topics Covered:
Introduction to VLOOKUP
How to use VLOOKUP with complex text strings
Practical examples and step-by-step guide
Tips and tricks for efficient data lookup
📊 Why Watch?
Understanding and mastering VLOOKUP can save you hours of work and make your data analysis more accurate and efficient. Learn how to tackle complex lookup scenarios with ease!
🔔 Don't Forget to Like, Share, and Subscribe!
If you find this tutorial helpful, please give it a thumbs up, share it with your colleagues, and subscribe to our channel for more Excel tips and tricks!
💬 Comments and Feedback:
We'd love to hear from you! Leave your questions and feedback in the comments below. What other Excel features would you like to learn about?
📚 Related Videos:
Mastering VLOOKUP in Excel
Advanced Excel Formulas and Functions
Tips for Efficient Data Management in Excel
Переглядів: 66

Відео

Unveiling the Mystery: What I Discovered Using Google Image Search
Переглядів 11121 день тому
Have you ever wondered what you can uncover with just a single image? In this video, I take you on a journey using Google Image Search to find the origins, details, and surprising information about a mysterious image I found. Watch as I explore various sources and piece together the story behind the image. Don't forget to like, comment, and subscribe for more intriguing content! Thanks for watc...
Efficient Student Score Compilation Using Power Query: One-Sheet Solution!
Переглядів 17921 день тому
In this tutorial, learn how to streamline your student score management using Power Query in Excel. I'll guide you through the steps to consolidate multiple individual student subject scores into a single, organized sheet. This method is perfect for educators and administrators looking to save time and enhance data organization. Whether you're managing grades, assessments, or evaluations, Power...
Merge Data Effortlessly | video no. 55 | Excel tips
Переглядів 5628 днів тому
Welcome to Video No. 55 in our Excel Tips series! In this tutorial, we'll show you how to merge data effortlessly in Excel. Whether you're combining multiple worksheets, consolidating information, or merging cells, this video has you covered. 🔍 What You'll Learn: How to use the "Merge & Center" function Tips for merging data from multiple sources Using the "CONCATENATE" and "&" functions to com...
How to Calculate Date Ranges Excluding Public Holidays Using Power Query
Переглядів 149Місяць тому
Formula:List.Dates([Start Date], Duration.Days([End Date] - [Start Date]) 1, #duration(1, 0, 0, 0)) In this video, I demonstrate how to use Power Query in Excel to calculate the count of dates between specified start and end dates, excluding public holidays. This step-by-step tutorial covers: Loading data into Power Query. Expanding date ranges to individual dates. Merging with a list of public...
Calculating Age in Excel is super easy! How to Calculate Age in Excel Using the DATEDIF Function
Переглядів 125Місяць тому
Welcome to our tutorial on calculating age in Excel using the DATEDIF function! Whether you're managing personal data or handling large datasets, knowing how to calculate age accurately is a valuable skill. In this video, we'll walk you through the steps to easily compute age from a date of birth.
How to Create a Cylinder Chart in Microsoft Excel - Step-by-Step Tutorial
Переглядів 64Місяць тому
How to Create a Cylinder Chart in Microsoft Excel - Step-by-Step Tutorial
How to Always Display the Cast Icon in Your Browser
Переглядів 26Місяць тому
How to Always Display the Cast Icon in Your Browser
How to Replace Words in Excel (and avoid unnecessary mistakes)
Переглядів 20Місяць тому
How to Replace Words in Excel (and avoid unnecessary mistakes)
How to Make Borders in Excel | Video 53
Переглядів 30Місяць тому
How to Make Borders in Excel | Video 53
How to Select Two Different Columns in Excel at the Same Time | video 52
Переглядів 35Місяць тому
How to Select Two Different Columns in Excel at the Same Time | video 52
How to Calculate the Median in Excel (Quick and Easy)
Переглядів 752 місяці тому
How to Calculate the Median in Excel (Quick and Easy)
How to Insert Bullet Points in Excel (Quick and Practical Solution)
Переглядів 502 місяці тому
How to Insert Bullet Points in Excel (Quick and Practical Solution)
How to Add Leading Zeros in Excel (Two Most Common Ways)
Переглядів 772 місяці тому
How to Add Leading Zeros in Excel (Two Most Common Ways)
Automate multiple excel file | AWESOME Excel trick to combine data from multiple sheets
Переглядів 692 місяці тому
Automate multiple excel file | AWESOME Excel trick to combine data from multiple sheets
How to Count Words in Excel (Quick and Easy)
Переглядів 252 місяці тому
How to Count Words in Excel (Quick and Easy)
How to Add Subscript in Excel (the Simplest Way)
Переглядів 372 місяці тому
How to Add Subscript in Excel (the Simplest Way)
How to Add the Dollar Sign in Excel (Quick and Easy)
Переглядів 242 місяці тому
How to Add the Dollar Sign in Excel (Quick and Easy)
How to Hide Gridlines in Excel (the Easy Way)
Переглядів 112 місяці тому
How to Hide Gridlines in Excel (the Easy Way)
How to Show or Hide the Formula Bar in Excel (Quick and Easy)
Переглядів 182 місяці тому
How to Show or Hide the Formula Bar in Excel (Quick and Easy)
How to Generate Random Numbers in Excel (3 Different Ways)
Переглядів 192 місяці тому
How to Generate Random Numbers in Excel (3 Different Ways)
How to color cell in excel? Video 41 | excel for beginners
Переглядів 272 місяці тому
How to color cell in excel? Video 41 | excel for beginners
How to Convert PDF to an Excel File (Quick and Easy) | video no. 40 | Excel for beginner
Переглядів 422 місяці тому
How to Convert PDF to an Excel File (Quick and Easy) | video no. 40 | Excel for beginner
How to Check Spelling in Excel and Avoid Typos
Переглядів 202 місяці тому
How to Check Spelling in Excel and Avoid Typos
How to Calculate Percentage Increase in Excel (The Right Way)
Переглядів 222 місяці тому
How to Calculate Percentage Increase in Excel (The Right Way)
How to Roundup and Rounddown in excel | Excel for beginner | Excel Series
Переглядів 132 місяці тому
How to Roundup and Rounddown in excel | Excel for beginner | Excel Series
How to Move columns in excel Pro tip 😧 | Excel for beginner
Переглядів 242 місяці тому
How to Move columns in excel Pro tip 😧 | Excel for beginner
How to Use AutoFill in Excel (Best Practices) | Excel for beginner | vidoe no. 35
Переглядів 242 місяці тому
How to Use AutoFill in Excel (Best Practices) | Excel for beginner | vidoe no. 35
How to Insert Comment and Note in Excel | Video no. 34 | Excel for beginner series
Переглядів 132 місяці тому
How to Insert Comment and Note in Excel | Video no. 34 | Excel for beginner series
How to Switch Rows and Columns in Excel (the Easy Way) | video no. 33 | Excel for Beginners
Переглядів 362 місяці тому
How to Switch Rows and Columns in Excel (the Easy Way) | video no. 33 | Excel for Beginners

КОМЕНТАРІ

  • @mohmoh7936
    @mohmoh7936 7 днів тому

    I can't not see the edit sign on samsung 😢

  • @srinivasan8023
    @srinivasan8023 9 днів тому

    Thanks

  • @pokosoft4
    @pokosoft4 9 днів тому

    please sorry one of my friend use a photo and win dv2025 but after the result i ask him to send me the photo used to be selected i use this photos with the website you show in this video the website reject the photo by saying that the head is bigger than ,thy is why i do not rely on these website of course it is good to use it but dont trust it 100% over 100% using this website to check is not official.

  • @stephenmartin6580
    @stephenmartin6580 10 днів тому

    Wow! You're my hero today! You just helped me de-hyphenate over 600 ISBN's without wearing out my keyboard... and myself! :)

  • @AzizagaAzizaga
    @AzizagaAzizaga 11 днів тому

    Everything is clear, vut for EndDate you didn't do anything. You just filtered values for StartDate and you do all process for StartDate, but main data refreshing also works for EndDate?! How does it possible?!

  • @shellylindahl7030
    @shellylindahl7030 11 днів тому

    Instruction/commentary is really necessary here for what I need

  • @AdanAbdi-cd6zd
    @AdanAbdi-cd6zd 11 днів тому

    Thanks bro

  • @WAibnMallickMallick
    @WAibnMallickMallick 11 днів тому

    Thank you

  • @ParfaitLukau
    @ParfaitLukau 11 днів тому

    Ayo

  • @PirateRadio-dq9oh
    @PirateRadio-dq9oh 12 днів тому

    You should do this in English,lol

  • @ThediGitalToolboX-rq1sn
    @ThediGitalToolboX-rq1sn 13 днів тому

    😮😮

  • @UGWUOBINNA-mr4ru
    @UGWUOBINNA-mr4ru 15 днів тому

    Why are you not talking

  • @JyotiYadav-oc1do
    @JyotiYadav-oc1do 17 днів тому

    भाई बोल कर बता देता

  • @cutiepatotie24
    @cutiepatotie24 19 днів тому

    OMG THIS IS SO HELPFUL AND THE ANSWER I WAS LOOKING FOR.🥰🥰

  • @happylove7145
    @happylove7145 20 днів тому

    How to send voice note

  • @pravinkumarn8867
    @pravinkumarn8867 22 дні тому

    Thanks Sir, Very Helpful Video

  • @hansgulbranson9506
    @hansgulbranson9506 23 дні тому

    My favorite part about this video was how it didn't do anything.

  • @seabear347
    @seabear347 Місяць тому

    The "bacteria growth" part doesn't make sense. If you're going to cook it what's the difference. Isnt that the main point ppl make when they say you don't need to deep clean chicken before cooking.

    • @vampr3751
      @vampr3751 9 днів тому

      i agree, maybe its a type of bacteria that isnt killed by heat 😅 i know theres something similar like that when it comes to reheating leftover rice

  • @MiloraKhatunstudent
    @MiloraKhatunstudent Місяць тому

    thank you brother

  • @saheshkarmacharya2869
    @saheshkarmacharya2869 Місяць тому

    current education minister of nepal

  • @liridoncani
    @liridoncani Місяць тому

    i have a similar scenario but when i drag the autofill i get an error on the 9th row that continues. i saw a video saying that formating a cell as a date doesnt actually consider it as a date but as a text. but it didnt explain anything more than that.i would appreciate some help here

  • @user-js7js6ny3k
    @user-js7js6ny3k Місяць тому

    Hello Hari viral, how to calculate dynamic calendar in work hours of works on excel

    • @HarryViral
      @HarryViral Місяць тому

      Will be making video soon 😀

    • @user-js7js6ny3k
      @user-js7js6ny3k Місяць тому

      @@HarryViral thank you, will be waiting

  • @mperson1890
    @mperson1890 Місяць тому

    The video does not keep up with your explanation. This video is a waste of time. No wonder there are no thumbs up!

  • @ThediGitalToolboX-rq1sn
    @ThediGitalToolboX-rq1sn Місяць тому

    very useful video🥰

  • @TechnoXoRoblox
    @TechnoXoRoblox Місяць тому

    Gyatt

  • @oliverwendel1489
    @oliverwendel1489 Місяць тому

    I do the exact same thing but it doesnt work?

  • @domjervis
    @domjervis Місяць тому

    Watched four times Went too fast Tried my best anyway Couldn't get it to work Going to try another site where hopefully someone can actually explain what needs to be done Thanks for nothing...UGH!

  • @maryellenbrooks2921
    @maryellenbrooks2921 Місяць тому

    What if I would like the sum to show as all minutes vs hours and minutes?

  • @digitalmarketingtipps
    @digitalmarketingtipps Місяць тому

    Very helpful. thanks bro.

  • @wandering_650
    @wandering_650 Місяць тому

    when the data is very huge and iF you want to find mathicng values and also identify which cell it is matching use this formula: =IFERROR("B is Present in A" & MATCH(B2, A:A, 0), "B is Absent in A")

  • @jmartinez0116
    @jmartinez0116 Місяць тому

    Where do i find billing zip code on a Venmo card?

  • @karthikm9205
    @karthikm9205 2 місяці тому

    Super ❤. I used it now

  • @verteeex
    @verteeex 2 місяці тому

    thank you! i tried to do it in google spreadsheets and online microsoft excel, but it is only doable in the microsoft excel program i think.

  • @SHYAMKumar-wp5cu
    @SHYAMKumar-wp5cu 2 місяці тому

    Absolutely the video is Awesome thanks ..

  • @namratashinde9157
    @namratashinde9157 2 місяці тому

    Could you please make video on how to write readable SQL code , and what are the formatting we should follow while writing SQL code

  • @sivanagchinta
    @sivanagchinta 2 місяці тому

    Formula not clear

  • @ChukeluEbele
    @ChukeluEbele 2 місяці тому

    Thats the wrong answer, John is 1.13 min not 1.22min

    • @dennywillyanto116
      @dennywillyanto116 Місяць тому

      It is 1.22 hours.. not minutes.. *60 if you need minutes

    • @dennywillyanto116
      @dennywillyanto116 Місяць тому

      Or you can multiply with 1440 if you need minutes

  • @santoshneupane3326
    @santoshneupane3326 2 місяці тому

    very useful 😍

    • @HarryViral
      @HarryViral 2 місяці тому

      Glad you think so! 😉

  • @Sweetyvlogs486
    @Sweetyvlogs486 2 місяці тому

    Very helpfull thank u

  • @yadavjii3506
    @yadavjii3506 3 місяці тому

    Sir mujhe google sheet mai Evey column mai every each word kay baad comma lagana automatically how it's possible

    • @HarryViral
      @HarryViral 2 місяці тому

      Google sheet can't do . Try in excel

    • @yadavjii3506
      @yadavjii3506 2 місяці тому

      @@HarryViral Sir please bata dijiye kaise hoga sir mainy kafi UA-cam video dekh li mujhe nhi samj aa raha hai sir

  • @yadavjii3506
    @yadavjii3506 3 місяці тому

    Hello sir I am your subscriber I need your help please help me sir 🙏🙏🙏

  • @kgdhammika7985
    @kgdhammika7985 3 місяці тому

    Ok

  • @zolpty1164
    @zolpty1164 3 місяці тому

    thanks for the video! Exactly what I was looking for! just subscribed👍

  • @fidhashafi6803
    @fidhashafi6803 3 місяці тому

    Sir,how to get these ad links to paste in ms word

  • @nbacontents354
    @nbacontents354 3 місяці тому

    Thank you

  • @Kalyani06
    @Kalyani06 3 місяці тому

    Formula is not clear.

  • @tanyalobakova5098
    @tanyalobakova5098 3 місяці тому

    Thank so,so much! Exactly what I was looking for!!!

  • @technicalengineer2532
    @technicalengineer2532 3 місяці тому

    Video not clear

    • @HarryViral
      @HarryViral 3 місяці тому

      Plz watch latest video with clear video I have made of this

  • @mmequleasing
    @mmequleasing 3 місяці тому

    thank you for this video, really helps my reports thousands data, btw, i am operation data supervisor

    • @HarryViral
      @HarryViral 3 місяці тому

      Welcome 🤗 plz Share this video and help others

  • @asbinedits7
    @asbinedits7 4 місяці тому

    How to do it on iPad? It doesn't show the edit sign