Sir,

I have two files one is payroll and other is advmaster
in adv master data is like this

emp name emp no. adv jan feb mar apr may......dec
jack k-123 5000 500 500 650 400
jill k-124 2000 100 100 100

in the payroll file

month : jan

emp name emp no pay ot total adv ded net
jack k-123 15000 15000
jill k-124 10000 10000

In the adv coloum i want a formula which should match the emp no of emp in
payroll and emp no of emp in adv master and parallely it should check the
month of payroll with month of adv master and to take that value to deduct.
can any one help me in this

regards

srinivas
--
srinivas