Troubles

[Jonas Krogh]

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?

 

[Roger Govier]

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

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