| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
