GVN KUMAR
Member
Sir,
we are each month salary drawing employee's list,
we are calculation for annul total salary how much & income tax liability?
our problem unique pan number for each employee different style entered but not summation of total each one how much drawing and income tax deduction how much
sir could u help of this below puzle
A B C
Employee Name Designation PAN No.
VENKATESWARLU CH PC AVCXC6843J
Subba ratnamma J.V Family PAN APPLIED
Suryakumari R Family AVWXR3994J
Venkateswarlu S SP PAN APPLIED
Narasimha Rao K SP PAN APPLIED
=VLOOKUP((C4),$A$4:$C$997,1,FALSE)
but not working sir in xls 2016.
where is my formula wrong sir
C coloumn pan no (unique in all months) entered automatic display name in A coloumn
could u suggest correct working formula
we are having 12 month 1000 employees pan nos (unique id of pan no for each one employee) list with same persons but different name entered in xls sheet.
a1 data name "venkateswarlu ch " entered our staff different names.
1 ch venki 4 venki 7 venkat c h 10 teswarlu
2 venki ch 5 chvenki 8 ch venkat 11 tech ch
3 ch. venki 6 venkich 9 venkatesh 12 ch. tech
so how to find correct name define each pan number but same all month same name
its eassy way to our software calculation income tax deductions how much?
suggest best formula
thank you for reading of post
we are each month salary drawing employee's list,
we are calculation for annul total salary how much & income tax liability?
our problem unique pan number for each employee different style entered but not summation of total each one how much drawing and income tax deduction how much
sir could u help of this below puzle
A B C
Employee Name Designation PAN No.
VENKATESWARLU CH PC AVCXC6843J
Subba ratnamma J.V Family PAN APPLIED
Suryakumari R Family AVWXR3994J
Venkateswarlu S SP PAN APPLIED
Narasimha Rao K SP PAN APPLIED
=VLOOKUP((C4),$A$4:$C$997,1,FALSE)
but not working sir in xls 2016.
where is my formula wrong sir
C coloumn pan no (unique in all months) entered automatic display name in A coloumn
could u suggest correct working formula
we are having 12 month 1000 employees pan nos (unique id of pan no for each one employee) list with same persons but different name entered in xls sheet.
a1 data name "venkateswarlu ch " entered our staff different names.
1 ch venki 4 venki 7 venkat c h 10 teswarlu
2 venki ch 5 chvenki 8 ch venkat 11 tech ch
3 ch. venki 6 venkich 9 venkatesh 12 ch. tech
so how to find correct name define each pan number but same all month same name
its eassy way to our software calculation income tax deductions how much?
suggest best formula
thank you for reading of post