Workbook link/match text/auto input

[freshstart]

Hello again,

This is a complicated request for a formula, i need a genius to help please!

I have two workbooks:

1. "Business Buddies"
2. Geography postcodes etc

In Workbook 1 i have postcodes in column I

I want the postcode to match up with the postcode in workbook 2 column E

When there is a match (there will be for 99%) I want the text in workbook 2 column J....

.....To be copied to workbook 1 column J.

Therefore, the formula will be entered in workbook 1 column J

hope this makes sense! any further questions please do ask!

[sweep]

Using INDEX and MATCH:

In workbook 1, column J

=INDEX([workbook2.xls]sheet1!J1:J10000,MATCH(I1,[workbook2.xls]sheet1!E1,E10000,0))

and copy down

[freshstart]

Thank you very much Welsh Wizard!

It worked! I have changed slightly for the benefit of purpose:

=INDEX('[All Knowsley Properties and Geographic Areas-IanCarrolan220807.xls]Properties040707'!$J:$J,MATCH(I3,'[All Knowsley Properties and Geographic Areas-IanCarrolan220807.xls]Properties040707'!$E:$E,0))

The matchup started with row 3 so had adapted appropriately.

workbook 1 has 270 rows
workbook 2 has 65,000 rows

sometimes i am asked to close other applications due to data memory etc and that external links could not be made, is that anything to be worried about?

Thanks again for such a swift and accurate reply!

[freshstart]

The excel message is:

"excel cannot complete this task with available resources. Choose less data or close other applications".

When closing this msg another box comes up with warning exclamation mark:

"Unable to save external link values".

Is this anything to worry about in the long term?

The values needed are entered ok can these lost?