Thread: Match Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Grip Grip is offline
external usenet poster
 
Posts: 1
Default Match Function

I have an Excel Workbook with 2 worksheets. One is lable A and the other one
is B.

In each worksheet there is a several columns A - L. In the first two
columns of each work sheet is two columns on with a date and one with a time.
Typically it will say Column A2 = 1/27/08 and B2: 1115. What I would like
to do is take the date and time from worksheet A then look on Worksheet B for
the same Date and time match and then copy the entire row from B to the
correct matching row on A.
So essentially I will have a row that has matching data from each table
combined to 1 worksheet so all data is lined up. This WorkSheet B data
should append to Column M with the rest lining up in order to the right.

Additionally, If there is no matching data it will just be a blank on the
row from column M right.

Thanks for any help. I looked this up and cannot find a solution.