I have a large data with two columns (Col. 1 Location, Col. 2 Code) in sheet
1.

in other sheet or workbook I want that, if I enter Location in cell then the
Code display in next cell using VLOOKUP or any other way.

kindly help me.

(I tried it using VLOOKUP but it not return the acurate value)

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