Genius World
Genius World
  • 247
  • 1 362 815
🔥 Power of VLOOKUP & MATCH Function In Excel | Easy Method
#howtouse #howtocreate #vlookup #vlookupformula #vlookupformula #vlookupinexcel #vlookupfunction #vlookuup #dropdown #dropdownlist #dependent #datavalidation #vlookupformula #vlookupinexcel #xlookup #msexcelxlookup #xlookupformula #max #maximum #maxformula #vlookupinexcelinhindi #msexcel
#msexcel2016 #msexcelfullcourse #GeniusWorld #@geniusworldteam
CZcams Handle : @geniusworldteam
Download Training File
docs.google.com/spreadsheets/d/19cSQZETwni2gX7GFLObHufK9ua4ZC3tw/edit?usp=sharing&ouid=100928782733267800224&rtpof=true&sd=true
In this video we will learn simple use of VLookup and learn it in very simply and easily. VLookup also known as Vertical Lookup in Microsoft Excel.
Here we will show multiple result for single lookup using VLookup Formula.
Please Subscribe to my channel and keep your support!!
#Matchfunction
#matchfunctioninexcel
#vlookupinexcel
#vlookupformula
#vlookup
#microsoft_excel_tutorial
Don't miss out on mastering these essential Excel functions - watch now and take your Excel skills to the next level!
Follow along as we walk you through the process step by step.
Timestamps:
0:00 Introduction
2:10 Use Data Validation In Excel
2:39 Test Data Validation Function
3:10 Use Data Validation in Heading
3:40 Use VLOOKUP & MATCH Function
5:10 Test VLOOKUP & MATCH Function In Excel
#Power of VLOOKUP & MATCH Function In Excel | Easy Method
*************** Kindly Like and Subscribe for Support ***********************
**************** Please Support our Page by Follow it ********************
MS-Excel-World-102496165764420/
The Channel URL also mentioned below;
youtube.com/@geniusworldteam
Excel Tutorial :
czcams.com/channels/5mb_OR4V3ryCJPONSQV89A.html
Don't forget to subscribe to our channel for more great Excel tutorials!
Visit us at: Genius-World...
zhlédnutí: 360

Video

How To Create Winner Template In Excel | VLOOKUP & MAX In Excel
zhlédnutí 45Před 21 dnem
#howtouse #howtocreate #vlookup #vlookupformula #vlookupformula #vlookupinexcel #vlookupfunction #vlookuup #dropdown #dropdownlist #dependent #datavalidation #vlookupformula #vlookupinexcel #xlookup #msexcelxlookup #xlookupformula #max #maximum #maxformula #vlookupinexcelinhindi #msexcel #msexcel2016 #msexcelfullcourse #GeniusWorld #@geniusworldteam CZcams Handle : @geniusworldteam Download Tra...
How To Create Drop Down List In Excel | Easy & Quick Method In Excel
zhlédnutí 438Před 28 dny
#howtouse #howtocreate #drop #dropdown #dropdownlist #dependent #datavalidation #vlookupformula #vlookupinexcel #xlookup #msexcelxlookup #xlookupformula #vlookupfunction #vlookupinexcelinhindi #msexcel #msexcel2016 #msexcelfullcourse #GeniusWorld #@geniusworldteam CZcams Handle : @geniusworldteam Download Training File docs.google.com/spreadsheets/d/1A8fZdjzNBcM_mqtx8OxS5N0jlACzoJDW/edit?usp=sh...
How To Use XLOOKUP Vs VLOOKUP Function In Excel | VLOOKUP Vs XLOOKUP In Excel Example
zhlédnutí 221Před měsícem
#howtouse #howtocreate #xlookup #vlookup #vlookupformula #vlookupinexcel #xlookup #msexcelxlookup #xlookupformula #vlookupfunction #vlookupinexcelinhindi #msexcel #msexcel2016 #msexcelfullcourse #GeniusWorld #@geniusworldteam CZcams Handle : @geniusworldteam Download Training File docs.google.com/spreadsheets/d/1Eyo7Dar84oihYzczoh3QgdyjOZJlrol-/edit?usp=sharing&ouid=100928782733267800224&rtpof=...
Easy Payroll System In Excel
zhlédnutí 82Před měsícem
#Advance #InventoryManagement #excelforbeginners #geniusworld Learn How to Create Payroll or Salary Statement in MS Excel. How to Calculate DA, HRA, PF, Gross Salary, EPF, LIC, Total Deductions, and Net Salary in Hindi, also learn how to format or Design Salary Sheet for your employees. Learn Excel basic formulas Sum, Percentage, Subtraction, etc. It is a complete ms excel training tutorial. CZ...
How To Use XLOOKUP Function In Excel | Easy XLOOKUP In Excel
zhlédnutí 938Před měsícem
#howtouse #howtocreate #xlookup #vlookup #vlookupformula #vlookupinexcel #vlookupfunction #vlookupinexcelinhindi #msexcel #msexcel2016 #msexcelfullcourse #GeniusWorld #@geniusworldteam CZcams Handle : @geniusworldteam Download Training File docs.google.com/spreadsheets/d/1VbOExiLjJ-wVgr_-_9z9e86oMHiJ99H7/edit?usp=sharing&ouid=100928782733267800224&rtpof=true&sd=true We learn about XLOOKUP funct...
How To Create Strike Through In Excel and Conditional Formatting In Excel
zhlédnutí 181Před 2 měsíci
#howtouse #howtocreate #data #datavalidation #Create #strikethrough #conditionalformatting #conditionalformattinginexcel #checkboxes #checkbox #conditionalformatting #msexcel #msexcel2016 #dataentryjobs #dataentryjop #dataentryjob #dataentrytips #msexcelfullcourse #GeniusWorld #@geniusworldteam @geniusworldteam CZcams Handle : @geniusworldteam Download Training File docs.google.com/spreadsheets...
Use of Performance FORM and How To Create FORM In Excel | Data Entry Form In Excel
zhlédnutí 156Před 2 měsíci
Use of Performance FORM and How To Create FORM In Excel | Data Entry Form In Excel
Use Of VLOOKUP & DATA VALIDATION Function In Excel | VLOOKUP Vs Data Validation In Excel
zhlédnutí 207Před 3 měsíci
Use Of VLOOKUP & DATA VALIDATION Function In Excel | VLOOKUP Vs Data Validation In Excel
Power of MACRO & IF Formula In Excel | Create & Use Excel Macros
zhlédnutí 67Před 3 měsíci
Power of MACRO & IF Formula In Excel | Create & Use Excel Macros
Use of INDEX & MATCH Function In Excel | How to use Excel Index Match
zhlédnutí 103Před 3 měsíci
Use of INDEX & MATCH Function In Excel | How to use Excel Index Match
Mastering Excel: Updating & Replacing Salary Data Tutorial
zhlédnutí 60Před 3 měsíci
Mastering Excel: Updating & Replacing Salary Data Tutorial
🔥 How to Create DICE GAME Macros in Excel Tutorial | MACRO CLASS # 03
zhlédnutí 93Před 6 měsíci
🔥 How to Create DICE GAME Macros in Excel Tutorial | MACRO CLASS # 03
How to Create Macros in Excel Tutorial | MACRO CLASS # 02
zhlédnutí 463Před 6 měsíci
How to Create Macros in Excel Tutorial | MACRO CLASS # 02
How to Create & Use Excel Macros | MACRO CLASS # 01
zhlédnutí 184Před 6 měsíci
How to Create & Use Excel Macros | MACRO CLASS # 01
🔥 How To Create Purchase Analysis Report In Excel
zhlédnutí 713Před 8 měsíci
🔥 How To Create Purchase Analysis Report In Excel
How to Use Excel Check Boxes | Easy & Simple In Excel
zhlédnutí 389Před 10 měsíci
How to Use Excel Check Boxes | Easy & Simple In Excel
How to Master Excel Tips & Tricks For Fastest Total
zhlédnutí 222Před 10 měsíci
How to Master Excel Tips & Tricks For Fastest Total
How to Master To Create Multiple Check Box In Excel | Thousands Check Boxes
zhlédnutí 1,8KPřed 10 měsíci
How to Master To Create Multiple Check Box In Excel | Thousands Check Boxes
Data Entry Form in Microsoft Excel | Power of Data Entry in Excel
zhlédnutí 188Před 11 měsíci
Data Entry Form in Microsoft Excel | Power of Data Entry in Excel
The Power of VLOOKUP | Use Of VLOOKUP | VLOOKUP In Excel
zhlédnutí 74Před 11 měsíci
The Power of VLOOKUP | Use Of VLOOKUP | VLOOKUP In Excel
🔥 Payroll in Excel | How to Create Payroll in Excel
zhlédnutí 9KPřed rokem
🔥 Payroll in Excel | How to Create Payroll in Excel
Data Entry using Form in Microsoft Excel | Excel Data Entry
zhlédnutí 207Před rokem
Data Entry using Form in Microsoft Excel | Excel Data Entry
How To Create Mark Sheet In Excel
zhlédnutí 3KPřed rokem
How To Create Mark Sheet In Excel
Use Conditional Formatting to Apply Strikethrough In Excel
zhlédnutí 8KPřed rokem
Use Conditional Formatting to Apply Strikethrough In Excel
How To Separate Big Data Text Into Different Columns
zhlédnutí 50Před rokem
How To Separate Big Data Text Into Different Columns
Create Professional PayRoll Using VLOOKUP Only | Single Formula Payslip
zhlédnutí 1,9KPřed rokem
Create Professional PayRoll Using VLOOKUP Only | Single Formula Payslip
6 Time Saving Formulas In Excel
zhlédnutí 89Před rokem
6 Time Saving Formulas In Excel
How To Count and Delete Blank Cells In Excel !!!
zhlédnutí 274Před rokem
How To Count and Delete Blank Cells In Excel !!!
How To Color Specific Text In Excel | Student Report
zhlédnutí 4KPřed rokem
How To Color Specific Text In Excel | Student Report

Komentáře

  • @trevorway4946
    @trevorway4946 Před 4 dny

    what if we don't want the "days' just a month/year column?

    • @geniusworldteam
      @geniusworldteam Před 4 dny

      We can simply use "m" for month and "y" for year. We don't need to use days. If we need only months and years.

  • @Sufa-k4v
    @Sufa-k4v Před 6 dny

    Payroll caculation

  • @moulkarshankar4765
    @moulkarshankar4765 Před 8 dny

    Thanks bro

  • @kamranahmed2295
    @kamranahmed2295 Před 10 dny

    Great

  • @lyn5946
    @lyn5946 Před 10 dny

    Hi, can u show a video of how by typing 0600- 0730 (as in 6.30 am to 7.30am) , in a cell , and it will colour a range of vertical cells? Like how i could easily highlight in colours of all enployees work time in a day, from what time till what time

    • @geniusworldteam
      @geniusworldteam Před 10 dny

      Thank You for your Comments. Please find the link of How To Create Payroll. We have used Over time and other detail. Hopefully it will be useful. czcams.com/video/c-kd145l0R4/video.htmlsi=R78BKfurVjFqcRuX

  • @dinowmoalimnour71
    @dinowmoalimnour71 Před 13 dny

    Very smart thank you ❤

  • @Chimera_166
    @Chimera_166 Před 16 dny

    Thanks friend❤❤❤

  • @giftsbeautyvlog144
    @giftsbeautyvlog144 Před 24 dny

    Thanks so very much

  • @user-df6cs1bm1i
    @user-df6cs1bm1i Před 25 dny

    Esme Logic kya hai pleej help

    • @geniusworldteam
      @geniusworldteam Před 25 dny

      It reflect True for Red Color !!!

    • @geniusworldteam
      @geniusworldteam Před 25 dny

      Is me ye pta krna hai k agr Red ho to "True" aye werna " False " aye

  • @phandongexcel
    @phandongexcel Před 29 dny

    I like this video ❤❤❤❤

  • @Anilasinha-mj3fn
    @Anilasinha-mj3fn Před měsícem

    Ty

  • @GuillermoOropeza-yb7te
    @GuillermoOropeza-yb7te Před měsícem

    Gracias!! me sirvió (:

  • @brokemomdiaries
    @brokemomdiaries Před měsícem

    This is exactly what I needed right now, thank you so much for the help

  • @dearest-tulip
    @dearest-tulip Před měsícem

    I love that with the power of tutorials, one does not need a college course to learn how to construct spreadsheets

  • @suhartoaliman4390
    @suhartoaliman4390 Před měsícem

    Can i do this in excel in office 365 version?

    • @geniusworldteam
      @geniusworldteam Před měsícem

      Usually the functions used in Google Spread Sheet and 365 are similar. You can make this function on Excel 365 as well.

  • @suhartoaliman4390
    @suhartoaliman4390 Před měsícem

    Can i do this in excel in office 365 version?

  • @karunakarvemishetty1134
    @karunakarvemishetty1134 Před měsícem

    Hi Sir....I want to give yes for greater than zero and no for less than zero and nil for equal to zero...will you please help me formula Sir

    • @geniusworldteam
      @geniusworldteam Před měsícem

      Thank You. You can use Yes instead of PASS and Any value like => for Instead of Fail. It works same. Still face issue. Please let me know. I will make formula

    • @karunakarvemishetty1134
      @karunakarvemishetty1134 Před měsícem

      ​@@geniusworldteamSir

    • @karunakarvemishetty1134
      @karunakarvemishetty1134 Před měsícem

      ​@@geniusworldteam Sir...Pass and Fail and nil ... three I need to give... above zero less than zero and equal to zero also condition please help me formula Sir

    • @geniusworldteam
      @geniusworldteam Před měsícem

      @karunakarvemishetty1134 Please find the Formula Below =IF(Select Cell>0,"Yes",IF(Select Cell<0,"No","Nill")) Hopefully it will work. If still face issue. Please let me know. I will create video on it in the coming days and share link with you.

  • @ericadenison1019
    @ericadenison1019 Před 2 měsíci

    Excellent very well done, for small business once they learn to print cheques they don't need to buy payroll software. I use excel for payroll I love it! I think once people truly understand how delightful and easy excel is to use for payroll ie. in small companies there will be far less demand for compensation and payroll software. Our company has less then 20 people, I can just add whatever I need.

  • @user-qv7nt4ll6f
    @user-qv7nt4ll6f Před 2 měsíci

    Sir Aisa koi formula nahi hai jo data ke + - find kare

    • @geniusworldteam
      @geniusworldteam Před 2 měsíci

      Please explain further we can convert all negative into positive etc

  • @TajudinAbdii
    @TajudinAbdii Před 2 měsíci

    Ok

  • @Hamza-plays-games165
    @Hamza-plays-games165 Před 2 měsíci

    Don’t understand 😁

  • @rudalmahato5619
    @rudalmahato5619 Před 2 měsíci

    Nice ...very informative video

  • @SexyLion-pu7ep
    @SexyLion-pu7ep Před 2 měsíci

    I don't have a result there, but a Value. Why? 😢

    • @geniusworldteam
      @geniusworldteam Před 2 měsíci

      Please use formula same formula and make sure nature / format of data is correct !!!

  • @Kerolos_Shaheedl
    @Kerolos_Shaheedl Před 2 měsíci

    Thanks bro

  • @dorcasgyasi514
    @dorcasgyasi514 Před 2 měsíci

    Neat work

  • @nachoGuitar
    @nachoGuitar Před 2 měsíci

    thanks bro

  • @hlulanipeseverence5269
    @hlulanipeseverence5269 Před 2 měsíci

    Thank you so much this is very simple and helpful 🙏🙏

  • @ProfAdamSelene
    @ProfAdamSelene Před 2 měsíci

    Sorry, das geht heute wirklich besser und einfacher!

    • @geniusworldteam
      @geniusworldteam Před 2 měsíci

      Yes, we can make it more easier and simpler or even complex as per requirement!!!

  • @rohitkhatokar1025
    @rohitkhatokar1025 Před 2 měsíci

    Thanks for the video however why the accent?

  • @lazyreviewssupport9811
    @lazyreviewssupport9811 Před 2 měsíci

    What is the use of this data & chart 📊 😢

    • @geniusworldteam
      @geniusworldteam Před 2 měsíci

      It is helpful to Summarize large data set in visual form in one of the simplest format !!

    • @lazyreviewssupport9811
      @lazyreviewssupport9811 Před 2 měsíci

      @@geniusworldteam this simply shows a simple data 75% in visual form... 😵 That's all... If this could atleast capture individual scores in each subject over a period of time, say 3 semester a chart 📊 could be useful 👍but here, a simple data, just percentage does not call for usage of chart 📊. As a matter of fact one person in comments 📝 had asked if this could be used for whole class... 😵 May be there a chart 📊 is required... 😵.. That's why I asked...

  • @lensalvado11681
    @lensalvado11681 Před 3 měsíci

    Hi do you have tutorial if 3 choices are needed? for example, pending, incomplete, complete?

    • @geniusworldteam
      @geniusworldteam Před 3 měsíci

      Apologize but we can make multiple scenarios like Pending, Work in process, complete and Cancelled bu using the same technique that has been used for normal scenarios. We will try to make video on multiple scenarios in near future. Thank you for your feedback!!!

  • @jeffereyskeels780
    @jeffereyskeels780 Před 3 měsíci

    Promo>SM

  • @mrittikachowdhury7388
    @mrittikachowdhury7388 Před 3 měsíci

    How i remove the color

    • @geniusworldteam
      @geniusworldteam Před 3 měsíci

      You can use Conditional Formatting option to add, remove or change the color.

    • @mrittikachowdhury7388
      @mrittikachowdhury7388 Před 3 měsíci

      Please write the steps, thanks

    • @geniusworldteam
      @geniusworldteam Před 3 měsíci

      @mrittikachowdhury7388 Hopefully these steps will work in the formatting, here are the steps to apply conditional formatting to change cell color in Excel: 1. Select the range of cells you want to apply the conditional formatting to. 2. Go to the "Home" tab on the Excel ribbon. 3. Click on "Conditional Formatting" in the Styles group. 4. Choose "New Rule" from the dropdown menu. 5. In the New Formatting Rule dialog box, select "Format only cells that contain" from the Select a Rule Type section. 6. Set your desired conditions under the "Format only cells with" dropdown menus. 7. Click on the "Format" button to choose the format you want to apply, including the font, border, and fill color. 8. Click "OK" to confirm the format. 9. Click "OK" again in the New Formatting Rule dialog box to apply the conditional formatting.

  • @joelsimonpraiseandworship649

    Simplified very well

  • @grasshopper0202
    @grasshopper0202 Před 3 měsíci

    It works in my laptop. But if I want to use in my tablet or phone. It seems the checkbox disappeared.

    • @geniusworldteam
      @geniusworldteam Před 3 měsíci

      Thank you for your feedback. You can check by installing different versions of Ms Office in order to support your file features.

  • @grasshopper0202
    @grasshopper0202 Před 3 měsíci

    Thank you very much.😊

  • @rajudarpalli7489
    @rajudarpalli7489 Před 3 měsíci

    tq dear really helpful 💛😊

    • @geniusworldteam
      @geniusworldteam Před 3 měsíci

      Thank you so much !!!

    • @rajudarpalli7489
      @rajudarpalli7489 Před 3 měsíci

      @@geniusworldteam brother sometimes coming like this the formula is missing an opening or closing parenthesis please tell me

    • @geniusworldteam
      @geniusworldteam Před 3 měsíci

      Thank you. You need to insert opening parenthesis but it for closing, you can insert or it will automatically create by own

  • @andu3206
    @andu3206 Před 3 měsíci

    Thanks very much 😊

  • @egoreruamoses8857
    @egoreruamoses8857 Před 3 měsíci

    Great and very helpful

  • @Mr.88Entertainment-yq6bn
    @Mr.88Entertainment-yq6bn Před 3 měsíci

    Thanks bro

  • @dancingcousins77
    @dancingcousins77 Před 3 měsíci

    How do u select the numbers like that

    • @geniusworldteam
      @geniusworldteam Před 3 měsíci

      You can select simpy by click on cell and drag till last. It will gives reference of selected cells

  • @chellayogavasan9435
    @chellayogavasan9435 Před 3 měsíci

    Super

  • @desiannwilliams1852
    @desiannwilliams1852 Před 3 měsíci

    I like this. Will be using it in my payroll journey

    • @geniusworldteam
      @geniusworldteam Před 3 měsíci

      Thank you for your feedback!!!

    • @ericadenison1019
      @ericadenison1019 Před 2 měsíci

      Yes I use excel for our small company too, works well. Just added a cheque printing template.

  • @publicdemand2389
    @publicdemand2389 Před 4 měsíci

    Excel sheet me tabal hai multiple copy kaise karre

  • @iampratikk
    @iampratikk Před 4 měsíci

    Superb. Short and to the point 👍

  • @eRIck-130ms-e2v
    @eRIck-130ms-e2v Před 4 měsíci

    This is one of the simplest video ever

  • @rahavan8939
    @rahavan8939 Před 4 měsíci

    Super sir...thank you so much 🎉🎉🎉🎉

  • @NoChecker
    @NoChecker Před 4 měsíci

    Yes thank you so much I have exam tomorrow and I was looking for this exact video thank you From Palestine 🇵🇸

  • @isaacmugala1656
    @isaacmugala1656 Před 4 měsíci

    Bravo