Automatically populate cells based on input of another cell

  • Thread starter Thread starter Carlton
  • Start date Start date
C

Carlton

I would like to set up a worksheet so that when I paste a certain
number, a zip code for example, into a column cell, information
corresponding to that number (i.e., zip code) automatically
appears in the cell to the right, in the same row.

Here's where it gets difficult (I think). My database has about
46,000 zip codes in it.

I've played with lists, etc., but they require that you scroll
through too many records to locate the corresponding record for
a particular zip code, and then you have to copy and paste.

Ideally, if I could get the cells to populate automatically, that
would be great.

The answer to this should assist others seeking to achieve similar
tasks.

Thank you in advance for your help.

Carlton R.
 
Carlton,

There are probably a lot of approaches you could take. One might be the
following

(Assume zip code in column A, and your desired data in column B)

In col B...

B1

=IF(ISBLANK(A1),"",VLOOKUP(A1,$F$1:$K$100,2,FALSE))

You could copy formula down Col B.

What the formula says is...

+ If A1 is blank, the B1 is blank

+ If A1 has data, then go to the lookup table F1:K100 and use A1 as the key
to find the desired data in the column

If you are not familiar with vlookup, you should read about it in XL help.
It is very useful function.

Again, this is probably one of many ways to solve this question.

HTH

Regards,
Kevin
 
Kevin, thank you very much!

This should help me alot. I will also
read up on vlookup.

Kind Regards,

Carlton R.
 
Back
Top