Hello,

I have three sheets in a workbook. The first sheet contains a project
plan from MS Project, the second sheet contains the same Project Plan,
except updated by Project Managers.

Here is where the fun begins. In the third sheet I'm trying to do a
MATCH from sheet 2 to sheet 1. But have the rest of the values in the
row move over to the third sheet as well. I'm able to match no problem
except it give me a "2" instead of the task name (which is what MATCH
does), but is there a way to I can use MATCH and OFFSET to bring over
the entire row? I basically want to get variances in start and finish
dates, complete %, etc. between the two plans.

Any help at all would be much appricated!! Thanks in advance!

Dave