Excel 2007 : Advanced cut & paste

**Ashduco** · 10-17-2011, 02:25 PM

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!

**arlu1201** · 10-17-2011, 02:28 PM

Yes vlookup will do it for you. You can read it up here to know how you can use it.

http://www.timeatlas.com/5_minute_ti...ookup_in_excel

**JBeaucaire** · 10-17-2011, 02:30 PM

Welcome to the Forum Ashduco.

First, please edit your post #1 above, GO ADVANCED if necessary, and remove the (Please Help!) from the title. It seems like trivial thing, but it is against the forum rules (Link above to Forum Rules, recommended reading, lots of useful info in there), and the moderators do flag things like that.

Second, what you want is absolutely doable and pretty simple. If the "postal codes" are in a database with the codes on the left, and the Northing/Easting flag on the right, a simple VLOOKUP() formula will suffice. Read up on VLOOKUP and give it a try.

If you can't put your post codes on the left, then switch to an INDEX/MATCH approach. I'd use VLOOKUP for this.