Vlookup or transform tool help

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.

Developer

Input

Join

Accepted answers

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

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

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

#Payment.JPG

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.

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.

Also as i have 1000+ emp ids

i have joined first with emp id

then with value

but then few results are missing

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

Payment Sheet 2.JPG