I am sure that you have come across many occasions where you have two lists of data and want to know if a specific item in List1 exists in List2.

Well I have!

With the MATCH function you can verify if a cell´s item in List1 exists in List2.

The function will return the row position of that item in List2 hence confirming that it exists.  If you get a #N/A it means that the cell´s item does not exist in List2.

You can then go ahead and filter your List1 with either the values returned or the #N/As.


Match - Two Lists




If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Consolidate with 3D Formulas in Excel 3D Formulas or References in Excel are a great way to consolidate data from multiple sheets.3D Formulas reference several worksheets that have the same structure which allows you to consolidate by using the SUM function.Formula breakdown:SUM(Sheet1:Sheet4!A1)...
Calculate Total Sales With An Array Formula An Array Formula performs an Excel operation (math, comparative, join or function argument) on an array or range of data.  This could be a range of cells, a worksheet reference or a defined name.One of the most popular uses of an array formula is to calculate Total Sales....
IF Function: Introduction The IF function is probably one of the most used Excel functions because it is easy to understand and very flexible when you apply it to real life situations.Here I will show you a couple of ways that you can use the IF function to get you up and going.DOWNLOAD WORKBOOK ...
Excel´s EndOfMonth function The EOMONTH (EndOfMonth) function in Excel is one that most people do not use because they just don't know that it exists.It is a great Excel function to use if you want to see when the month end date is from a current date's value.So if you have sales reps who make a sal...