Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
read a column of names and place a number in the next cell
I want to automatically read a column of suburb names and add a column of
matching street directory map numbers. I have to do this monthly on several different worksheets. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
read a column of names and place a number in the next cell
Judy
If you have a table with the suburbs and matching map numbers you could use the VLOOKUP Function. Assume on sheet2 you have column A with suburbs, column B with matching numbers. On sheet1 you have suburbs names in Colimn A. In B1 enter a VLOOKUP formula =VLOOKUP(A1,SHEET2!$A$1:$B$200,2,FALSE) Double-click on the fill handle to copy down. Gord Dibben Excel MVP On Wed, 7 Dec 2005 14:43:03 -0800, "Judy Hallinan" <Judy wrote: I want to automatically read a column of suburb names and add a column of matching street directory map numbers. I have to do this monthly on several different worksheets. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I link one cell to a list of info in another workbook? | Excel Discussion (Misc queries) | |||
copying text across sheets | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
Percentage of overall attendance | Excel Discussion (Misc queries) |