Hi fl

Use the VLookup function
Look in the Excel help for examples

If you need help post back

--
Regards Ron de Bruin
http://www.rondebruin.nl


"fl" wrote in message ...
In sheet1, I have two columns:

27678 dallas
76050 arlington
106658 houston
128089 san francisco
167864 los angeles
182951 los angeles
232856 los angeles
233358 houston
237150 houston
274164 houston
283867 dallas
370187 dallas

In sheet2, I have column 1, I need to find the match for column2.
Example,

76050 ?
237150 ?

What is the formular to find arlington for 76050 and houston for
237150? Thanks.