Match and Vlookup method

[JackMouct]

Hi Everyone, Please find attached data and i am trying to create code that will do exactly as an example tab (sheet 3) in data attached. All i want is to pull for one part and then second part value to match the same emplyee. In other words, if employee pay pension contributions for 100 (Pen EE (Tal)) and employer pay for 200 (Pen ERS (Tal)) on behalf of the same employee. Then, the worksheet should look like Colunm A= Pers No, Column B=Employee Name, Colunm C= ID Number, Column D=PenPay, Column E=Pens EE(Tal) and Column F=Pens ER(Tal) and G= Total (Pen EE +Pen ER values), as exactly in example tab.

I hope this makes sense. i have tried several methods but no luck far. Thank you all for your help. Please find attached


Data Download.xlsm

[Zack Barresse]

Cross-posted:

http://www.mrexcel.com/forum/excel-q...-criteria.html
http://www.excelforum.com/showthread...7957&highlight

@JackMouct: please read: http://www.excelguru.ca/content.php?184

[Aussiebear]

Zack, its not the first time the OP has been warned about cross posting.

[Zack Barresse]

Thanks Ted.

@JackMouct: be warned. Continuing to cross-post will result in revocation of your posting privileges here. Please read the link I posted. It explains why we don't permit this, nor do any other forums. Take care & have a great New Year's!