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!
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!
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.
> 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 ~
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
