Smart Office
Smart Office
  • 172
  • 2 058 971
VLOOKUP and MATCH Function Together | Automate Column Index Numbering in VLOOKUP
Learn how we can combine the MATCH function within VLOOKUP to make the column index number automatic. This saves lot of time in finding the values from one data source to another. Formula in one single cell can be filled across any number of row and columns.
Download the sample data file to practice this function from the link given below.
Workbook Number:
zhlédnutí: 55

Video

Complete Guide to VLOOKUP Exact Match Function
zhlédnutí 94Před 21 hodinou
Unlock the full potential of Excel with our step-by-step guide on using the VLOOKUP function for exact matches! In this tutorial, you'll learn how to efficiently search for and retrieve specific data from your spreadsheets, making your workflow more efficient and accurate. Whether you're a beginner or looking to refine your Excel skills, this video covers everything you need to know about VLOOK...
A Complete Guide on MATCH Function of Excel
zhlédnutí 100Před 14 dny
In this tutorial you will learn how to use the MATCH function in Microsoft Excel. MATCH function is used for finding the row number or column number of an item in an array based on exact, less than and greater than match.
RANKX Function Tutorial in Power BI
zhlédnutí 116Před 21 dnem
Learn how to use the RANKX function in Power BI. RANKX function is used for finding the rank of items based on their values. Download the practice workbook file from below link. 1drv.ms/u/s!AohAxi9JX1lu2ydAlo-FgbR4Ioa6?e=ZpnGAQ
Best Software for Editing Video for YouTube | Microsoft Clipchamp Video Editor
zhlédnutí 120Před měsícem
Learn how to edit videos for CZcams by using Microsoft Clipchamp Video editor. This video editor is 100% free, lightweight and easy to use video editing software. How to edit video for CZcams | Free Video editing Software | Best software for video editing | Microsoft Clipchamp tutorial
How to Make Video of Power Point Presentation
zhlédnutí 58Před 2 měsíci
In this video you will learn how to make a video file from Microsoft Power Point Presentation. ppt to video | export power point presentation to video file | how to make video from a ppt document
How to Edit PDF Document with MS Word
zhlédnutí 206Před 2 měsíci
Learn how to edit the PDF documents with Microsoft Word. Edit PDF | Convert PDF to Word | Edit and Save PDF Document
How to Use Microsoft Office 365 for FREE
zhlédnutí 242Před 2 měsíci
Learn how we can use Microsoft Office 365 for FREE. This is only the authentic method of enjoying the latest features of office application without purchasing the program. Use Office Programs for Free | Office 365 Free | Microsoft Office Free | Excel 365 free |
Solve GIF Image Not Playing in WordPress Post
zhlédnutí 85Před 3 měsíci
Learn how to solve the problem of animated GIF image not playing in WordPress Post.
Find Out Forgotten Wi-Fi Password Connected in Computer🔥
zhlédnutí 235Před 3 měsíci
Learn how we can find out the forgotten password of Wi-Fi that is connected in a Computer.
Power BI Line Chart for Monthly Sales in Jan to Dec Order
zhlédnutí 219Před 3 měsíci
Learn how to make a line chart in Power BI to display the sales trend in Jan to Dec order. Download the Excel sample file to practice this project from below. Sample. 2 learnexcelandsheets.com/video-tutorials-and-sample-excel-sheets-for-power-bi/
XLOOKUP in Google Sheets👍(3 Practical Examples🔥)
zhlédnutí 223Před 3 měsíci
Learn how to use the XLOOKUP function in Google Sheets. Here you will learn using XLOOKUP in different data situations with 3 examples. Download the practice sheet from link below. Workbook Num. 7 (locate this in webpage below) learnexcelandsheets.com/excel-practice-workbook-collection-so-a/
Fill Handle Drag and Drop Not Working in Excel | Follow These Steps
zhlédnutí 120Před 3 měsíci
Fill Handle Drag and Drop Not Working in Excel | Follow These Steps
What is Fill Handle in Excel (Tutorial for Beginners)
zhlédnutí 124Před 3 měsíci
What is Fill Handle in Excel (Tutorial for Beginners)
Calculate and Visualize Running Total in Power BI using Measure
zhlédnutí 725Před 7 měsíci
Calculate and Visualize Running Total in Power BI using Measure
How to Add Background Image in Excel
zhlédnutí 2,8KPřed 7 měsíci
How to Add Background Image in Excel
Calculate Running Total in Power BI using DAX function
zhlédnutí 615Před 7 měsíci
Calculate Running Total in Power BI using DAX function
How to Calculate % of Total in Excel
zhlédnutí 417Před 7 měsíci
How to Calculate % of Total in Excel
DAX in Power BI (Tutorial for Beginners)
zhlédnutí 975Před 7 měsíci
DAX in Power BI (Tutorial for Beginners)
Power BI Tutorial for Beginners
zhlédnutí 715Před 7 měsíci
Power BI Tutorial for Beginners
AVERAGE + Take Function in Excel | Automate Last N Months Average Calculation
zhlédnutí 594Před 7 měsíci
AVERAGE Take Function in Excel | Automate Last N Months Average Calculation
How to Add Background Image in Word
zhlédnutí 329Před 7 měsíci
How to Add Background Image in Word
How to Auto Highlight Duplicate Values in Google Sheets
zhlédnutí 1,9KPřed 8 měsíci
How to Auto Highlight Duplicate Values in Google Sheets
How to Calculate % Increase or Decrease in Excel
zhlédnutí 1,9KPřed 8 měsíci
How to Calculate % Increase or Decrease in Excel
Aggregate Function in Excel
zhlédnutí 883Před 8 měsíci
Aggregate Function in Excel
How to Remove Grand Totals From Pivot Table Report
zhlédnutí 2,3KPřed 8 měsíci
How to Remove Grand Totals From Pivot Table Report
Convert Number to Spelling in MS Word with One Click Button
zhlédnutí 6KPřed 8 měsíci
Convert Number to Spelling in MS Word with One Click Button
Learn How to Make Star Rating in Excel
zhlédnutí 6KPřed 8 měsíci
Learn How to Make Star Rating in Excel
Learn how to do Calculations in Filtered Data In Excel
zhlédnutí 2,3KPřed 8 měsíci
Learn how to do Calculations in Filtered Data In Excel
Generate Automatic Serial Number in Excel
zhlédnutí 4,1KPřed 8 měsíci
Generate Automatic Serial Number in Excel

Komentáře

  • @NitaYahqina-l4j
    @NitaYahqina-l4j Před 9 hodinami

    Thanks my dear friend. Issue was driving me nuts but, video was very helpful

  • @1373abby
    @1373abby Před 13 hodinami

    Thank you!!! Extremely helpful!

  • @kartiksahani6109
    @kartiksahani6109 Před dnem

    Nice explanation

  • @lingdumpling5967
    @lingdumpling5967 Před dnem

    Thank you, you life saver

  • @chronixlovee
    @chronixlovee Před 2 dny

    What if I am trying to count the number of cells greater than zero? my table has "hours late" where your "attendance" column is. I am trying to count the number of cells greater than 0 when data is filtered.

  • @lindaezeani8133
    @lindaezeani8133 Před 2 dny

    Please sir where can i download this excel. The link isn't working. Please help

  • @rizafabia5343
    @rizafabia5343 Před 3 dny

    Please correct me when im wrong ? is the formula is *$G4+"Paid" thanks

  • @fredpayne2464
    @fredpayne2464 Před 3 dny

    Can't understand him, anybody know where to find this in Ehglish?

  • @mrgirishsbce
    @mrgirishsbce Před 4 dny

    Fantastic video , short and exact to the point

  • @jhyrq
    @jhyrq Před 4 dny

    What if I wanted to apply it to multiple sheets at the same time?

  • @DEDEPLDEDE
    @DEDEPLDEDE Před 6 dny

    Unfortunately it doesn't work anymore as Windows is unable to see the content of the zipped file

  • @variedinterest1
    @variedinterest1 Před 7 dny

    How do I highlight a cell just by clicking on it and leave it highlighted

  • @naziralifarooq5899
    @naziralifarooq5899 Před 10 dny

    Can we use same formula on google sheet?

  • @aryan8104
    @aryan8104 Před 10 dny

    Thanks for the video, it really solved my problem to manually change the column number

  • @divinkottummal5128
    @divinkottummal5128 Před 10 dny

    This formula works in libra calc too. very useful video. thank u so much.

  • @archieducation
    @archieducation Před 10 dny

    Thanku bro

  • @tejanfamily659
    @tejanfamily659 Před 11 dny

    Please assist us with the video for the development of the POS system, please

  • @chandusheth
    @chandusheth Před 11 dny

    =SUMPRODUCT(B5:M5*($B$4:$M$4=$B$4)) &=SUMPRODUCT(B5:M5*($B$4:$M$4=$C$4)) will solve the problem.

  • @malikawais633
    @malikawais633 Před 13 dny

    Thanks very much bro❤

  • @REDALKLLC
    @REDALKLLC Před 14 dny

    Hello - Seems very interesting, However I cant seem to find where exactly to download the template?

  • @cesarminiao
    @cesarminiao Před 15 dny

    This doesn’t work on web excel 😞

  • @Kumquat-qq8tf
    @Kumquat-qq8tf Před 15 dny

    It wouldnt work for me using ' but did with "

  • @himangiyadav8094
    @himangiyadav8094 Před 15 dny

    You haven't considered the mark up margn, directly 8% pe nikal diya hai Gross profit.

  • @TK604
    @TK604 Před 15 dny

    Fantastic - Thanks!

  • @YohannesTesfu-b5o
    @YohannesTesfu-b5o Před 16 dny

    Brilliant explanation and, I think, it would be great if you could share the excel file for downloading and easier practice by your subscribers. Thanks a lot!!

  • @nanyuwati3356
    @nanyuwati3356 Před 16 dny

    Thanks.Lifesaver.

  • @DogeBasje
    @DogeBasje Před 19 dny

    Thnak you! Any idea how this option got turned of in the first place?

  • @mukeshnaidu6380
    @mukeshnaidu6380 Před 21 dnem

    Thank you so much

  • @muhammadezzat6326
    @muhammadezzat6326 Před 21 dnem

    very useful, simple, clear and so easy Thank You

  • @lindanoor7485
    @lindanoor7485 Před 22 dny

    Hi im sorry. I find your video very helpful. Did you by any chance sell the template?

    • @increase-work-productivity
      @increase-work-productivity Před 22 dny

      Hello, this template is free to download in video description

    • @lindanoor7485
      @lindanoor7485 Před 21 dnem

      @@increase-work-productivity Hi Thanks!! Will this work for a large inventory? Since we are keeping track for purchase item this too will help right?

  • @anwerali1201
    @anwerali1201 Před 23 dny

    Thank you very very very much... Very much very much..... So grateful to you... I recovered my work which I deleted by mistake

  • @ministerpetrabanda4380

    Am unable to download this template, site not going through

  • @ashkumarmagar4201
    @ashkumarmagar4201 Před 24 dny

    Thank you sir

  • @faizmuhammad3597
    @faizmuhammad3597 Před 24 dny

    Sir very good template, I am waiting for learning this template step by step as you promised

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

    can you the VBA code to me ? I cant open you link .. please.. I need it very much.

  • @timster_
    @timster_ Před 26 dny

    Very helpful. Goated video. Would reccomend

  • @user-hm3et3fl9x
    @user-hm3et3fl9x Před 27 dny

    Good video

  • @the_hinchy
    @the_hinchy Před 27 dny

    What do I press instead of dollar sign? Sounds like cookie but I can’t work it out, sorry for the misunderstanding. Is it a shortcut on the keyboard?

  • @prabhuprabha9297
    @prabhuprabha9297 Před 27 dny

    Very useful 👍

  • @stevenwork_31
    @stevenwork_31 Před 27 dny

    feel sad that this is not advance search condition, i need to have search something like input "(Raj AND indian) OR (PK AND INDian)", this simple criteria. U this is simple search, not advance search LOL

  • @omurfaruk4955
    @omurfaruk4955 Před 28 dny

    The Drop-down list on the Poshandle does not pull through from the Itemgroup, can you help me please

    • @increase-work-productivity
      @increase-work-productivity Před 19 dny

      if possible, please share your workbook in spreadsheetforu@gmail.com we will check and revert.

  • @azimsaleh7507
    @azimsaleh7507 Před 29 dny

    Great! What if we want to put date instead of word.

    • @increase-work-productivity
      @increase-work-productivity Před 19 dny

      in case of date, need to put the number value of date. for example, (3rd Aug 2024 = 45507, 4th Aug 2024 = 45508)

  • @amzy3142
    @amzy3142 Před 29 dny

    Nimber not converting to lacs or corore for indian rupees

  • @mekeshavraj
    @mekeshavraj Před 29 dny

    if customers total due amount is 1lakh but paid 20,000 then how this system catch this

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

    Thanks a lot. Suppose we have to find max value among Jan to December and how to get name of that month and item using a formula. Hope you can suggest a solution.

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

    The link is invalid sir

  • @MathiasKing-j4b
    @MathiasKing-j4b Před měsícem

    Great tutorial. I enjoyed the sequential approach. It was very helpful. Please how do you handle a situation where you placed an other for two different products, say Products A and B, but had only product A delivered. If you replace the 'T' with 'R' for Product A, how do you deal with product B which you are yet to receive? Thanks.

    • @increase-work-productivity
      @increase-work-productivity Před měsícem

      It assumes that the transit quantity in one column is delivered together. If not, we have to keep undelivered product in another column and mark it as transit

  • @bsit33_dominguezcriselleb.23

    I've been trying to expand my knowledge in Excel and it's really helpful to me. Thank you for this.

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

    Thanks a lot 🙏

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

    Thanks a lot🎉