View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
graymore393 graymore393 is offline
external usenet poster
 
Posts: 2
Default How to merge 2 Excel files that need to match on 2 different colum

I have 2 worksheets that are set up with similiar fields. The difference is
one worksheet is from one year and the other worksheet is another year. I
would normally use a vlookup function to join the 2 files but I need to match
these 2 worksheets using 2 columns (e.g. car make and car dealer). Thanks.