Lookup and Match

[Thomas Kuriakose]

Respected Sirs,

We have two tabs receivables and payables for unit codes as in the attached file.

We need to match the unit code of receivables with the corresponding unit codes of payables based on the voucher number.

It is possible that one receivable unit code has multiple payable unit codes based on the voucher and vice-versa.

I tried a pivot table ,but could not get the correct result.

Kindly suggest the correct way to get the result.

Thank you very much,

with regards,
thomas

 

[Thomas Kuriakose]

Respected Sirs,

I tried with power pivot to combine both tabs for the pivot table, but it is giving same values for all unit codes.

Kindly find attached the result which is incorrect from the pivot.

I don't know whether my method is correct.

Kindly guide me on the correct lookup and match,

with regards,
thomas