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!
Last edited by Ashduco; 10-17-2011 at 02:43 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
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.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks