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.

#googlesheets #compare

[lisamildenberger]

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

[taitaasersiron]

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

[danmurphy]

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

[daniel]

great tutorial. Thank you for sharing your knowledge.

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

[waqarahmad]

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

[ryan]

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

[bocobox]

U are just another level. Thanks for the video.

[syedarshad]

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"

[seccisec]

Love your videos! Just wanted to say that!

[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

[michaelking]

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.

[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

[ninamariearong]

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.