Excel 2007 : Advanced cut & paste

For my dissertation I am mapping all the rugby clubs in England, all 1206 of them. I have a list of Rugby Clubs names with associated postcodes but to map I need the eastings and northings, which I have all the eastings and northings for ALL postcodes in the UK, but obviously on a different excel document.

Basically is there a way to run a command or a formula that will search the selected postcodes from document A (Rugby clubs names and postcodes) on document B (All postoces and Eastings & Northings) and autofill them from B into A so I don't have to cut and paste manually and individually for 1206 rows!

Please please help!