Search : in
By :

MATCHING THE DATA AND

Last answer on Nov 8, 2009 1:58:44 am GMT CHETHAN, on Nov 7, 2009 10:47:48 am GMT 
 Report this message to moderators

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

Best answers for « MATCHING THE DATA AND » in :
Backup Outlook 2003 data ShowBackup Outlook 2003 data All Outlook 2003 data ( Emails, Agenda, Contacts, Tasks...) are in one file with .pst extension The file is in the following default folder: C:\Documents and Settings\Login\Local Settings\Application...
Watch football matches live ShowWatch football matches live Playing football with his ISP Playing football on the Internet Streaming Online Streaming Watching Football matches on Peer to peer acceess Playing football with his ISP A subscription offers access...
[Ingres] Importing/ Exporting data Show[Ingres] Importing/ Exporting data Making use of these commands copydb unloaddb Notes Ingres allows you to export data from an Ingres installation to another (it is a platform independent procedure). unloaddb copydb The main...
Download Sim Card Data Backup Tool Show
Download Data Terminator Show
Download Home Data Keeper Program ShowHome Data Keeper Program helps you to program the whole functions related to your home. This program contains more than 35 features which help you to track information about your home, car, etc. You can edit and display information about your...
Data transmission - Cabling ShowCabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted...
Data transmission - The physical connection ShowWhat is a transmission channel? A transmission line is a connection between two machines. The term transmitter generally refers to the machine that sends the data while receiver refers to the one receiving the data. The machines can sometimes be...
Data transmission - Introduction ShowData representation The purpose of a network is to transmit information from one computer to another. To do this, you first have to decide how to encode the data to be sent, in other words its computer representation. This will differ according to...
Ask your question Reply

1

 venkat1926, on Nov 8, 2009 1:58:44 am GMT

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

   
Reply to venkat1926
Ask your question Reply
They need your help