# Match /Vlookup/ Manipulate data base on Criteria

Status
Not open for further replies.

#### JackMouct

##### New Member
Hi Everyone, I am trying to create code that will help me achieve the correct format. All i want is to pull employee (EE) entire row and pates into new sheet and and then second part (ER) 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.

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Can you show us how you have the raw data layed out? Is the employer compansation automatic so it can be calculated?

I am leaning towards pivot tables.

A B C D E F
Pers.No Name ID Number Pension Type Pensionable Pay Amount Net Amount
008835 Jack Wilson NE54315 Pens EE(Tal) 827.57 45.52
008835 Jack Wilson NE54315 Pens ER(Tal) 827.57 162.20

I need to a code that can do below example lay out. I am fairly new on VBA coding

A B C D E F G
Pers.No Name ID Number Pensionable Pay Amount Pens EE(Tal) Pens ER(Tal) Total
008835 Jack Wilson NE54315 827.57 45.52 162.20 207.72 (45.52+162.20)

Thank you again for you help

Status
Not open for further replies.

Replies
1
Views
199
Replies
1
Views
728
Replies
4
Views
696
Replies
13
Views
2K
Replies
0
Views
565

1,216,481
Messages
6,130,919
Members
449,606
Latest member
jaybar0812

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back