Compare Lists or Tables in Google Sheets Using VLOOKUP or MATCH Functions - Part 1

Поделиться
HTML-код
  • Опубликовано: 30 окт 2024

Комментарии • 34

  • @taitaasersiron4375
    @taitaasersiron4375 3 месяца назад

    Thank you! Best explanation on YTB right now, nice and clear 😊

  • @lisamildenberger4128
    @lisamildenberger4128 2 года назад

    OMG!! THANK YOU THANK YOU!!! You have saved me from so much frustration! Comparing 2 different sheets!

  • @danmurphy7338
    @danmurphy7338 4 года назад +1

    This is great, look forward to you showing me how to prevent or hightlight a duplicate from different sheets.

  • @jojobopo
    @jojobopo 3 года назад

    Thank you so much for this. I've been trying to figure this out for over a week!

  • @sebiporini
    @sebiporini Год назад

    I am learning a lot with your videos. I really enjoy them, you are a great teacher and it seems you are a great person too. Thank you very very very much for all your videos, all you good mood and the wise you spread. I am turning into a more productive and professional person thanks to you. Cheeeeers!

  • @daniel76900
    @daniel76900 2 года назад

    great tutorial. Thank you for sharing your knowledge.

  • @mostainbillah
    @mostainbillah 3 года назад +1

    Thanks for the tutorial

  • @waqarahmad1651
    @waqarahmad1651 Год назад

    Sorry to bother you, i have 2 diff sheets sir, but you working on same sheet?like we use importrange for 2 sheets? but i have 2 diff sheet with data, suppose i enter new data so if the data is matching with my new entry so it shouild highlight.please help sir, Thanks

  • @syedarshad6985
    @syedarshad6985 3 года назад +1

    very helpful, I have got a question for you, what if I need custom text for each condition. for example instead of true I want it to return as "old customer" and for false "new customer"

  • @bocobox
    @bocobox 4 года назад

    U are just another level. Thanks for the video.

  • @mangafreak5514
    @mangafreak5514 Год назад

    So If I want to compare two different values and return pre define numerical value how do I do that ?
    For example I have select country in 1st column drop down , then select product code and then I need to fill another column Relevant price automatically based on the selection. How do I do that ? I've been searching for that over 3h now.. Please help me Sir. Ican do the dropdown part with data validation.. and depend product code using index. But I can't return a product price which should be automatic

  • @ryan05108
    @ryan05108 10 месяцев назад

    what if I filter a different sheet? Will it highlight only the filtered items?

  • @seccisec
    @seccisec 4 года назад

    Love your videos! Just wanted to say that!

  • @sheetomatic
    @sheetomatic 4 года назад

    Good One

  • @vishey
    @vishey 4 года назад +1

    Hi,
    Your videos are great.. Can you please help or suggest is there any way to stop duplicate entries for any specific item or more then one item which contains the same value as duplicate via Google form to google sheet. I explain more, anyone can submit as many responses as they want via google form but I want any duplicate entry for any specific items should automatically be cleared from the linked google sheet or something like that

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  4 года назад +1

      You won't be able to prevent it from being entered. However, you can run a script to check for duplicates and remove them when a new line is submitted.

    • @vishey
      @vishey 4 года назад

      @@ExcelGoogleSheets yeah, thank You. So On Edit trigger will work here .. right ??

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  4 года назад

      @Vishal Form submit developers.google.com/apps-script/guides/triggers/events#form-submit

    • @vishey
      @vishey 4 года назад

      @@ExcelGoogleSheets thank You very Much.. I have done it..

  • @justbelit
    @justbelit 3 года назад

    Question. Column A has a list of customer names, column B has all the different items purchased by each customer. Where A2 is: [Jane Doe] and B2 is: [item1, item2, item3, item4] and so on. The store offers 20 standard items, so some customers choose 3 items, some 7, some 9 and so on. How do we separate all the items into individual columns, then run a formula that will insert the customer names under each item they purchased. This is an ongoing order list submitted via google forms, so the formula needs to search and categorize customers according to item1, item2, item3, each time it is submitted

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  3 года назад +1

      Looks like you need filter function and then VLOOKUP customer name next your results from FILTER.

  • @michaelking9156
    @michaelking9156 4 года назад +1

    Hi - your videos are always awesome. Been looking for a solution for GDocs that allows one to use app script in making in a doc different page orientation portrait and landscape. Any ideas? Many thanks.

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  4 года назад

      Have you tried setting setPageHeight(pageHeight) & setPageWidth(pageHeight) for body?

  • @ninamariearong3033
    @ninamariearong3033 3 года назад

    Hi, thank you for this tutorial; it helps me a lot. But, I have some concerns; some of the data did not highlight even though they are on the other sheet. What are the possible reason for this issue and how can I avoid? Thank you so much.

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  3 года назад +1

      That would happen if the data didn't match. Maybe some difference in spelling, spaces, commas, etc.

  • @cheewurz
    @cheewurz 4 года назад

    Okay

  • @MauricioHernandez87
    @MauricioHernandez87 4 года назад

    why IF and not ISBLANK

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  4 года назад

      2 different things. ISBLANK checks for true blanks, ="" checks for blanks or empty strings. So long as you understand the difference you should be able to use the one that fits the situation.