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.

DOWNLOAD WORKBOOK

Match - Two Lists

HELPFUL RESOURCE:

hmb_logo_01Lg

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

INDEX Function Introduction The INDEX function in Excel returns a cell´s values from within a table/array. It works like a map, so you have to select a range (table/array) and tell it to return you the coordinates (Row & Column numbers). So if you want to return values from a Price List or large d...
Named Ranges with Vlookup Formula What does it do? Searches for a value in the first column of a table array and returns a value in the same row from another column (to the right) in the table array. Formula breakdown: =VLOOKUP(lookup_value, table_array, col_index_num, ) What it means: =VLOOKUP...
VLOOKUP Multiple Columns What does it do? Searches for a value in the first column of a table array and returns the sum of values in the same row from other columns (to the right) in the table array. Formula breakdown: {=SUM(VLOOKUP(lookup_value, table_array, {col_index_num1,col_index_num2}, ))}...
Excel Subtotal Function – Filtered or Visible Valu... What does it do? It returns a Subtotal in a list or database Formula breakdown: =SUBTOTAL(function_num, ref1) What it means: =SUBTOTAL(function number 1-11 includes manually-hidden rows & 101-111 excludes them, your list or range of data) ***Go to the bottom...