VLOOKUP

  • Thread starter adeel via OfficeKB.com
  • Start date
A

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)
 
C

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)
Click to expand...

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
 
A

adeel via OfficeKB.com

Thanks it works.....
I have a large data with two columns (Col. 1 Location, Col. 2 Code) in sheet
1.
Click to expand...
[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
Click to expand...
 
Top