VLOOKUP

[adeel via OfficeKB.com]

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)

 

[carlo]

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)

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

 

[adeel via OfficeKB.com]

Thanks it works.....

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

[quoted text clipped - 8 lines]
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