I have a problem i hope for your help to solve.

I have a list of all the zip-codes in one column (A2:A1430) and the
city-names in the column to the right (B2:B1430).

Now, i want Excell to show the cityname in a cell when i enter the zip-
code in an other cell.

Can anybody help?

Hi Jonas

Assuming your lists are on sheet1 and you are entering the Zip code in A1 of
Sheet2 and want the city to appear in B1

=IF(A1="","",VLOOKUP(A1,Sheet1!A:B,2,0))
Copy down as required

--
Regards
Roger Govier

"Jonas Krogh" wrote in message
...
I have a problem i hope for your help to solve.

I have a list of all the zip-codes in one column (A2:A1430) and the
city-names in the column to the right (B2:B1430).

Now, i want Excell to show the cityname in a cell when i enter the zip-
code in an other cell.

Can anybody help?

__________ Information from ESET Smart Security, version of virus
signature database 4531 (20091022) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4531 (20091022) __________

The message was checked by ESET Smart Security.

http://www.eset.com