read a column of names and place a number in the next cell

J

Judy Hallinan

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.
 
G

Gord Dibben

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
 
Top