Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Function
I have a list of information that I have imported to a worksheet. In this
list here is a column of Townships coded as numbers. I have created a list of the townships on another sheet (township-names) with the corresponding number in another column. Is there a function that I can use to look up the township name and replace the number in the original worksheet which I have imported? -- Ronnie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Function
Why not insert a column beside the old township numbers and use VLOOKUP() to
lookup the new numbers. Lookup value would be Sheet old!townshipname If this post helps click Yes --------------- Jacob Skaria "Ronnie" wrote: I have a list of information that I have imported to a worksheet. In this list here is a column of Townships coded as numbers. I have created a list of the townships on another sheet (township-names) with the corresponding number in another column. Is there a function that I can use to look up the township name and replace the number in the original worksheet which I have imported? -- Ronnie |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Function
I'm still working on getting the VLOOKUP to work. I must be doing something
wrong. -- Ronnie "Jacob Skaria" wrote: Why not insert a column beside the old township numbers and use VLOOKUP() to lookup the new numbers. Lookup value would be Sheet old!townshipname If this post helps click Yes --------------- Jacob Skaria "Ronnie" wrote: I have a list of information that I have imported to a worksheet. In this list here is a column of Townships coded as numbers. I have created a list of the townships on another sheet (township-names) with the corresponding number in another column. Is there a function that I can use to look up the township name and replace the number in the original worksheet which I have imported? -- Ronnie |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Function
Post the VLOOKUP formula.
The basics are =VLOOKUP(cell,table range,column index,false) You have a list of ID numbers in Sheet1 column A to A200 In colulmn B enter =VLOOKUP(A1,Sheet2!$A$1:$B$200,2,FALSE) Copy down to B200 Where Sheet2 coumn A is ID numbers and Column B is township names. Gord Dibben MS Excel MVP On Tue, 8 Sep 2009 13:10:40 -0700, Ronnie wrote: I'm still working on getting the VLOOKUP to work. I must be doing something wrong. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |