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

Learn how to compare two lists (tables) in Google Sheets. We'll be primarily using MATCH function, however, we'll also walk through doing it using VLOOKUP.
Part 2 • Compare Two Sheets for...
#googlesheets #compare

[@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]

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"

[@ryan05108]

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

[@danmurphy7338]

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

[@mostainbillah]

Thanks for the tutorial

[@taitaasersiron4375]

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

[@ExcelGoogleSheets]

Glad it was helpful!

[@vishey]

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]

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]

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

[@ExcelGoogleSheets]

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

[@vishey]

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

[@michaelking9156]

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]

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

[@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

[@lisamildenberger4128]

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

[@ExcelGoogleSheets]

:)

[@daniel76900]

great tutorial. Thank you for sharing your knowledge.

[@justbelit]

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]

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

[@jojobopo]

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

[@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!

[@ExcelGoogleSheets]

👍

[@ninamariearong3033]

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]

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

[@sheetomatic]

Good One

[@ExcelGoogleSheets]

Thanks

[@cheewurz]

Okay

[@bocobox]

U are just another level. Thanks for the video.

[@ExcelGoogleSheets]

Thank You!

[@seccisec]

Love your videos! Just wanted to say that!

[@ExcelGoogleSheets]

I appreciate that!

[@MauricioHernandez87]

why IF and not ISBLANK

[@ExcelGoogleSheets]

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.