How to link a column with the other file

[vsr_kmb]

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

The head office will update on a weekly basis the master file and
need to update my file based on the head office update. I need t
udpate the purchase requisition number, purchase order number, purchas
order date ete... from the master to my file in local. As a example
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 whic
corresponds to the site requisition number by putting formula?.

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

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

 

[Ardus Petus]

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 (here: column E)

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

HTH
--
AP


"vsr_kmb" <[email protected]> a écrit
dans le message de
news:[email protected]...

 

[vsr_kmb]

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