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.

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.

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.

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.

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.