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.