If two geographical data match in two sheets, copy unique id/code found in one sheet

OTPM · #2 09-01-2011, 05:23 AM

Hi
Here is the formula to use:

=VLOOKUP(F2,[2011_OFFICIAL_GEOGRAPHIC_CODE.xls]GEOGCODE!$E:$F,2,FALSE)

However in the worksheet you are reading the code from the code column will need to be in Column F. The formula will look for the STREET in Column E and return the code from Column F.
This formula should be in column A in your target worksheet otherwise you will need to change the references slightly.
Hope this helps.
Any problems come back to the forum.
Good luck.
Tony(OTPM)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to syncronize data in two different sheets	diegogeid	Excel	2	09-30-2010 12:19 AM
How do I merge data from one sheet in a workbook out into multiple sheets	nolesca	Excel	4	06-07-2010 08:13 AM
Any tutorial same as to this excel sheet with code?	Learner7	Excel	1	05-18-2010 05:31 PM
copy cell from sheet 2 to sheet 3 macro	slipperyjim	Excel Programming	1	02-18-2010 01:31 AM
How can I use a colom of data if a specific value is found.	Grapejuice	Excel	1	08-11-2006 11:44 PM