How to find this value

F

fl

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.
 
R

Ron de Bruin

Hi fl

Use the VLookup function
Look in the Excel help for examples

If you need help post back
 
R

Ron de Bruin

OK

Data range in Sheet1 = A1:B20 for example

In Sheet2

A1 : 76050
B1 : =VLOOKUP(A1,Sheet1!A1:B20,2,FALSE)

It will look for 76050 in the first column of the data range and display
the value from the second column (see the number 2 in the formula)
 
Top