Matching and create variable

[mahershams]

Dear Concern

Please help me to write a code to find a match value based on four criteria between two sheets in the attached excel file to create a variable:

same year
same industry
same size (+-30% of size matching between the firms)
same NPAT/TA (-+10% of NPATTA)

If match found, then g2 cell of sample firm sheet will retrieve the value of +-10% of NPATTA variable from "all firm sheet".

Thank you in advance.

Regards
Shams

[mahershams]

Any help from any one.

[mahershams]

Hi

Just to give a more explanation of this problem:
1. First criteria is to match year and industry which is very straight forward. Say this criteria generates 100 match firms.
2. In second stage, 100 matched firms can be reduced to +-30% by checking the difference between BV/MV value. The difference between the BV/MV of these two samples are considered and takes those -+30% which have lowest differences.
3. From these matched firms, final matching is based on NPATTA. Again from these +-30% sample firms, it will pick the match firm which have the lowest difference between NPATTA between two sample group.

I think the coding would be something like this to solve this problem. Can any one help?

Regards
Shams