VLOOKUP
 

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

VLOOKUP
 

On Nov 15, 2:38 pm, "adeel via OfficeKB.com" <u32736@uwe wrote:
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.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

VLOOKUP
 

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