Thanks it works.....

carlo wrote:
I have a large data with two columns (Col. 1 Location, Col. 2 Code) in sheet
1.
[quoted text clipped - 8 lines]
--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/ms-excel/200711/1

hi adeel

Vlookup should work perfectly.
A1 is the cell you enter your location.
B1 is following formula:
=Vlookup(A1,sheet1!A:B,2,false)

Change sheet1!A:B to whatever your sheet is.
the false is important, otherwise excel doesn't give you the
correct answer.

hth

Carlo

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200711/1