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
Configuration: Windows XP Internet Explorer 8.0
In the first file use VLOOKUP function
|
Besides mail merge, what are other ways you can share data from excel with other applications Call of duty modern warfare 2 wont find me a match Cod modern warfare 2 mutiplayer corrupt data Data recovery when pc does not detect external drive Data stored in rom is earesed when the power is off? Data traveler 400 driver 8gb Driver xp data interface kyocera e2000 Eliminating unnecessary data on ubuntu hard drive Excel macro copy data from one cell into another Gps dongle-data logger How to read binatone data files How to send data to parallel port Hp laserjet 1010 printer technical data Lg 32lh4010 tech data Recover xbox 360 save data Samsung c3050 usb data cable Wireless security setting on computer does not match the setting on the router Wwe smackdown vs raw 2010 ps3 save data