I have been trying to rectify the anomalies in the data in a
spreadsheet that has become a mishmash of different Project and Task
codes in order to provide a structure so that a final spreadsheet or
database can be constructed that makes sense.

I have 2 sheets of an Excel 2003 workbook,

Sheet 1 has 11000 entries the first four columns are ProjectID,
NewProjectID, TaskID and NewTaskID with 10 other columns.
NewProjectID and NewTaskID are currently empty columns and I am
looking for a formula that will populate them from sheet2

Sheet 2 has about 500 unique entries with the same first four columns
ProjectID, NewProjectID, TaskID and NewTaskID and all four columns are
completed I have extracted every single unique combination from Sheet1
to create sheet 2 and allocated a NewProjectID or NewTaskID.

What I am trying to do now is write the formulas for sheet1,
NewProjectID so that where sheet1 ProjectID = sheet2 ProjectID and
Sheet1 TaskID = sheet2 TaskID then it picks up the NewProjectID in
sheet2 and enters it into the corresponding column in sheet1. I also
need to do exactly the same to create a formula to pick up the
NewTaskID.

I could do all this manually but with 11000 entries it's going to take
a considerable time . The problem is the more I look at it the more
confused I have become. Probably because I am so close to it and I've
trying to rationalise all the options for four days

Unfortunately the TaskID have about seven different ways of coding and
there are nine different methodologies for the projectID which led to
so much of my confusion in the first place.

Can anyone help, I really am at my wits end. I am sure it will be a
relatively simple formula using something like match and vlookup or
something along those lines but my head is a plate of mince and I
really have to get this done

Any help would be gratefully appreciated

Thanks

BJthebear
Scotland