Function

  • Thread starter Thread starter Ronnie
  • Start date Start date
R

Ronnie

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?
 
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
 
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
 
Back
Top