How to link a column with the other file
 

I have one file in local for material puchase requisitions from the site
with site requisition number, originator, description ete. And there is
one file in the company's network for all the site's material
requisitions with the purchase requisitions details like purchase
requisition number, purchase order number, purchase order date ete...

The head office will update on a weekly basis the master file and i
need to update my file based on the head office update. I need to
udpate the purchase requisition number, purchase order number, purchase
order date ete... from the master to my file in local. As a example i
have entered only few entries, in actual there are so many enteries.

My question is how can i input the details from the master file which
corresponds to the site requisition number by putting formula?.

I have attached the Excel files.
I need help from the experts.
Thanks


+-------------------------------------------------------------------+
|Filename: Direct purchae_Site.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4613 |
+-------------------------------------------------------------------+

--
vsr_kmb
------------------------------------------------------------------------
vsr_kmb's Profile: http://www.excelforum.com/member.php...o&userid=32834
View this thread: http://www.excelforum.com/showthread...hreadid=531772

How to link a column with the other file
 

Enter formulae like:
=INDEX('[Requisitions Master.xls]Sheet1'!$E:$E,MATCH($B3,'[Requisitions
Master.xls]Sheet1'!$B:$B,0),1)

Adjust column to be extracted (he column E)

See example: http://cjoint.com/?elhK4ndamT

HTH
--
AP


"vsr_kmb" a écrit
dans le message de
...

I have one file in local for material puchase requisitions from the site
with site requisition number, originator, description ete. And there is
one file in the company's network for all the site's material
requisitions with the purchase requisitions details like purchase
requisition number, purchase order number, purchase order date ete...

The head office will update on a weekly basis the master file and i
need to update my file based on the head office update. I need to
udpate the purchase requisition number, purchase order number, purchase
order date ete... from the master to my file in local. As a example i
have entered only few entries, in actual there are so many enteries.

My question is how can i input the details from the master file which
corresponds to the site requisition number by putting formula?.

I have attached the Excel files.
I need help from the experts.
Thanks


+-------------------------------------------------------------------+
|Filename: Direct purchae_Site.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4613 |
+-------------------------------------------------------------------+

--
vsr_kmb
------------------------------------------------------------------------
vsr_kmb's Profile:
http://www.excelforum.com/member.php...o&userid=32834
View this thread: http://www.excelforum.com/showthread...hreadid=531772

How to link a column with the other file
 

Thanks very much and it is working excellent
With kind regards,
Ravi


--
vsr_kmb
------------------------------------------------------------------------
vsr_kmb's Profile: http://www.excelforum.com/member.php...o&userid=32834
View this thread: http://www.excelforum.com/showthread...hreadid=531772