Dear Friends;

I am trying to use this function to #NA replace with 0, First the
Index & Matchfunctions worked well ,later on when i added ISNA and
Vlookup it shows only 0 at all rows. Plese review and looking for
correction from your end


=IF(ISNA(VLOOKUP(B3,Data!$A$5:$B$97,2,FALSE)),0,IN DEX(Data!$A$5:$A
$97,MATCH(B3,Data!$B$5:$B$97,FALSE),1))


thanks & kind regars

Hi

What you got when you use
=IF(ISNA(VLOOKUP(B3,Data!$A$5:$B$97,2,FALSE)),0,VL OOKUP(B3,Data!$A$5:$B$97,2,FALSE))
or
=IF(ISERROR(INDEX(Data!$A$5:$A$97,MATCH(B3,Data!$B $5:$B$97,FALSE),1)),0,INDEX(Data!$A$5:$A$97,MATCH( B3,Data!$B$5:$B$97,FALSE),1))


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"SG" wrote in message
ups.com...
Dear Friends;

I am trying to use this function to #NA replace with 0, First the
Index & Matchfunctions worked well ,later on when i added ISNA and
Vlookup it shows only 0 at all rows. Plese review and looking for
correction from your end


=IF(ISNA(VLOOKUP(B3,Data!$A$5:$B$97,2,FALSE)),0,IN DEX(Data!$A$5:$A
$97,MATCH(B3,Data!$B$5:$B$97,FALSE),1))


thanks & kind regars