Excel - merging, matching or detecting identical data
I have been tearing out what is left of my hair trying to sort data in a spreadsheet. The long and short of it is I have a sheet of data related to tasks for a maintenance programme, I have another sheet containing maintenance manual references related to the first, one column in each sheet holding identical data (task references) but the first sheet has a few extra items not duplicated in the second. Obviously, I want to match the maintenance manual references with the tasks on one sheet.
I've tried purportedly "free" merge or join software but full functionality has to be paid for (I'm cheap). Apparently Excel 2007 has something called Lookup or similar but I'm jiggered if I can sort it out.
Has anyone a reasonably simple way of explaining how I go about joining these data?