|
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
|
|
#1
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 |
Windows 7 32bit 
Office 2010 32bit
Hybrid Mode