MATCHING THE DATA AND

Closed
CHETHAN - Nov 7, 2009 at 05:47 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 7, 2009 at 08:58 PM
Hello,
I have Two MSExcel files,
1. DATA CONTAING OF MANY DEPOSITORS.
2. PERMANENT ACCOUNTS NO's ( PAN ) OF THE DEPOSITORS.

Firstly , all the depositors do not have the PAN.
Secondly , in the First File the Names of the Depositors are not in order.
But all the depositors have UNIQUE CODE NO.

I have entered all the UNIQUE CODE NO of the depositors who have the PAN in the Second file.

Now, I want a formula to:

Search the UNIQUE CODE NO from the Second file and return the PAN of that particular UNIQUE CODE in the next column in the First file.
( I cannot add the data in the same file , because the First File data wll be chaging from month to month )

Please help me how can I write the formula

Reg
CHETHAN
MYSORE - KARNATAKA - INDIA

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Nov 7, 2009 at 08:58 PM
in the first file use VLOOKUP function
I am giving you a trivial example
in sheet 2 A1 to B5 is
name pan
a 1
s 2
d 3
f 4
in sheet 1
name pan
d

the Pan for d is not available here
in B2 type this formula
=VLOOKUP(A2,Sheet2!$A$1:$B$5,2,FALSE)
you will get 3

can you work on this If so confirm
read help under this fucntion
0