how to find pan holder name in list of pan nos through vlookup formula not working

[GVN KUMAR]

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

 

[GraH - Guido]

Hi, you want to lookup the PAN of column C in the list of Names in column A. So the formula returns N/A, because no PAN will match a name.
Where is your lookup table?
I believe you need a table with all names and matching PAN. Which you can use in the month lists to lookup PAN for matching names.

 

[Peter Bartholomew]

What you have shown us to date does not match the basic use for VLOOKUP. The function is designed to be used within one table to look up additional details from a second table. Assuming you are using this table to look up an employee name knowing their PAN No, I would expect the formula itself to be in a different table.

The current table is not set up in an ideal manner for VLOOKUP; it is better that the column you are searching for a match is the first column on the left and, in addition, the processing would be much faster if that column were sorted alphabetically. If the column you are searching is not on the left then it is more straightforward to use the MATCH function to find the record number and INDEX to return data from the record.

You have also requested that column 1 (the column that you have just searched to find your Required PAN) is returned, so it should return nothing that is not already known. Finally the PAN No. BKTXV9979N is shown as belonging to both Narayana Rao V and PITCHI BABU VARIKUNTA, violating the uniqueness requirement.

 

[GVN KUMAR]

THANK YOU SIR ALL OF PETER BARTHOLOMEW SIR + GRAH GUIDO

BEST SUGGEST SIR
ANY FORMULA FOR THIS TYPE OF PROBLEM SIR