Vlookup or transform tool help

[Kiara16]

Hi

using two sheets payment and salary sheet

can someone help me to build the workflow

i have a payment type and its amount in payment sheet

and salary sheet i want to compare 

1) amount is correct as per payment sheet

2) only those are paid which are mentioned in payment sheet.

[Deano478]

@Kiara16 what do you mean by "only those are paid which are mentioned in payment sheet."

[Deano478]

I have something so you can have a look and let me know:

[Bren_Spill2]

@Kiara16 - is the attached what you're looking for?

 

[Kiara16]

For example: joining bonus is not paid to emp id 5

but in salarysheet we can see 200 rs is reflecting under joining bonus column Therefore this is an exception.

[Kiara16]

But this is not highlighting exception-

For example: joining bonus is not paid to emp id 5

but in salarysheet we can see 200 rs is reflecting under joining bonus column Therefore this is an exception.

[Bren_Spill2]

@Kiara16 - update attached.

[Kiara16]

Also as i have 1000+ emp ids 

i have joined first with emp id

then with value

but then few results are missing

[Bren_Spill2]

@Kiara16 - you'll need to join on more than id and value.