On Sun, 28 Jan 2007 17:12:00 -0000, Vas
wrote:

Hi

i am puting this formula but still it showing error.

=IF(ISNA(
LOOKUP(2,1/((B2='Data-hokair'!$A$1:$A$1000)*(Data!$O$1='Data-hokair'!$C$1:$C$1000)),'Data-hokair'!$D$1:$D$1000)

Is this right, lookup syntax is
"LOOKUP(lookup_value,lookup_vector,result_vect or)

Lookup_value is a value that LOOKUP searches for in the first vector.
Lookup_value can be a number, text, a logical value, or a name or
reference that refers to a value.

Lookup_vector is a range that contains only one row or one column. The
values in lookup_vector can be text, numbers, or logical values."

so you are looking up 2 in 1/(.....) - looks wrong to me

Steve


,0,LOOKUP(2,1/((B2='Data-hokair'!$A$1:$A$1000)*(Data!$O$1='Data-hokair'!$C$1:$C$1000)),'Data-hokair'!$D$1:$D$1000))

"SteveW" wrote:

isna() function

something like this

=if(isna(lookup....),0,lookup....)
Steve


On Sun, 28 Jan 2007 13:44:00 -0000, Vas
wrote:

I am putting Lookup function.suppose if value is not there in table
array.
it is giving #N/A. I want 0 instead of #N/A. How ? Pleae help me.

Regd.

Vas