Zip code lookup

P

pastortom

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I want to enter a zip code in sheet 1 column D and return a county name from sheet 2 to sheet 1 column E. Help!
 
B

Bob Greenblatt

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
Intel I want to enter a zip code in sheet 1 column D and return a county
name from sheet 2 to sheet 1 column E. Help!
Click to expand...
Assuming that you have table of county names and zip codes in sheet 2,
then you simply need a hlookup formula in each cell of column E in sheet
1. Put the formula in the first cell in column E (make sure you have the
correct relative and absolute references) and then fill it down for the
number of cells needed.
 
T

tclawser

> Assuming that you have table of county names and zip codes in sheet 2,
> then you simply need a hlookup formula in each cell of column E in sheet
> 1. Put the formula in the first cell in column E (make sure you have the
> correct relative and absolute references) and then fill it down for the
> number of cells needed.
>
> --
>
> Bobgreenblattatmsndotcom
> Thanks for your help - it's working and so am I ~
Click to expand...
 
Top