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!