Thread: [Solved] match two columns of data
View Single Post
 
Old 08-03-2014, 07:10 AM
gbaker gbaker is offline Windows 7 32bit Office 2010 32bit
Competent Performer
  
Join Date: May 2012
Posts: 111
gbaker is on a distinguished road
Default match two columns of data
I need a formula that will match 2 columns of data. The numbers I want to match are in different columns and in different rows. What formula would find the matches in both arrays and put a 1 next to the ones that match. see example spreadsheet attached.
Attached Files
File Type: xlsm TEST MATCH.xlsm (9.6 KB, 9 views)
Reply With Quote