Fromual Help

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

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