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