Thread: If two geographical data match in two sheets, copy unique id/code found in one sheet
View Single Post
 
Old 09-01-2011, 05:23 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default
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)
Reply With Quote