Excel Forum

Excel Magic Trick 382: Match Two Lists, Extract Column Data From Each List

Match date in List 1 with List 2, if there is a match take second column from each table and put them in new table. See VLOOKUP and Filter Method and VLOOKUP-SUMPRODUCT-INDEX-MATCH Method.

Got a Question? Ask it Here in the Forum.