Fromual Help

[Bonnie]

I have a spreadsheet with a column of zip codes, a column
of depot numbers and another column of zip codes (more
zips than the first column) I am currently looking at
the first column of zips, finding that zip in the second
column of zips and then assigning it the depot number
manually. Is there a way to automate this?

thank you.

 

[Frank Kabel]

Hi
if col. A+B are zip codes + depot number and col. E stores your other
zip code list enter the following in F1
=VLOOKUP(E1,$A$1:$B$1000,2,0)
and copy down

 

[Guest]

Actually colum A is zip codes; column B is depot numbers
and column C is other zip codes. I need new depot
information to go into column D. How can I rework the
formula?

thanks so much.

 

[Frank Kabel]

Hi
just put the following in D1
=VLOOKUP(C1,$A$1:$B$1000,2,0)