Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP function
if the exact lookup_value is not found, it will approximate to the nearest
figure below the requested value. For Example: Code Name Qty. 10 Ali 3434 11 Vahid 356 13 Farid 67 14 Mohammad 324 15 Farbod 785 In "Code" column, "12" does not exist. When I Lookup column "Code", it will be as follow: Code Name Qty. 10 Ali 3434 11 Vahid 356 12 Vahid 356 <------- (This row is the same as "11") 13 Farid 67 14 Mohammad 324 15 Farbod 785 I want to have empty cells or zero when there is not "12". Please help me. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP function
Use VLOOKUP(). Refer help for details and syntax
=IF(ISNA(VLOOKUP(10,A1:C6,2,0)),"",VLOOKUP(10,A1:C 6,2,0)) To retrun the 3rd column (Qty) VLOOKUP(10,A1:C6,3,0) If this post helps click Yes --------------- Jacob Skaria "Arfa" wrote: if the exact lookup_value is not found, it will approximate to the nearest figure below the requested value. For Example: Code Name Qty. 10 Ali 3434 11 Vahid 356 13 Farid 67 14 Mohammad 324 15 Farbod 785 In "Code" column, "12" does not exist. When I Lookup column "Code", it will be as follow: Code Name Qty. 10 Ali 3434 11 Vahid 356 12 Vahid 356 <------- (This row is the same as "11") 13 Farid 67 14 Mohammad 324 15 Farbod 785 I want to have empty cells or zero when there is not "12". Please help me. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP function
If you have Excel 2007, you can use IfError
=IFERROR(VLOOKUP(10,A1:C6,2,TRUE),"") -- __________________________________ HTH Bob "Arfa" wrote in message ... if the exact lookup_value is not found, it will approximate to the nearest figure below the requested value. For Example: Code Name Qty. 10 Ali 3434 11 Vahid 356 13 Farid 67 14 Mohammad 324 15 Farbod 785 In "Code" column, "12" does not exist. When I Lookup column "Code", it will be as follow: Code Name Qty. 10 Ali 3434 11 Vahid 356 12 Vahid 356 <------- (This row is the same as "11") 13 Farid 67 14 Mohammad 324 15 Farbod 785 I want to have empty cells or zero when there is not "12". Please help me. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP function
Many Thanks.
I use Excel 2003. "Bob Phillips" wrote: If you have Excel 2007, you can use IfError =IFERROR(VLOOKUP(10,A1:C6,2,TRUE),"") -- __________________________________ HTH Bob "Arfa" wrote in message ... if the exact lookup_value is not found, it will approximate to the nearest figure below the requested value. For Example: Code Name Qty. 10 Ali 3434 11 Vahid 356 13 Farid 67 14 Mohammad 324 15 Farbod 785 In "Code" column, "12" does not exist. When I Lookup column "Code", it will be as follow: Code Name Qty. 10 Ali 3434 11 Vahid 356 12 Vahid 356 <------- (This row is the same as "11") 13 Farid 67 14 Mohammad 324 15 Farbod 785 I want to have empty cells or zero when there is not "12". Please help me. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP function
Arfa, does that means you have resolved the issue ?
"Arfa" wrote: Many Thanks. I use Excel 2003. "Bob Phillips" wrote: If you have Excel 2007, you can use IfError =IFERROR(VLOOKUP(10,A1:C6,2,TRUE),"") -- __________________________________ HTH Bob "Arfa" wrote in message ... if the exact lookup_value is not found, it will approximate to the nearest figure below the requested value. For Example: Code Name Qty. 10 Ali 3434 11 Vahid 356 13 Farid 67 14 Mohammad 324 15 Farbod 785 In "Code" column, "12" does not exist. When I Lookup column "Code", it will be as follow: Code Name Qty. 10 Ali 3434 11 Vahid 356 12 Vahid 356 <------- (This row is the same as "11") 13 Farid 67 14 Mohammad 324 15 Farbod 785 I want to have empty cells or zero when there is not "12". Please help me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Lookup function and Sum function | Excel Worksheet Functions | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |