View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fl fl is offline
external usenet poster
 
Posts: 10
Default How to find this value

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.