Correction of Function

S

SG

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,INDEX(Data!$A$5:$A
$97,MATCH(B3,Data!$B$5:$B$97,FALSE),1))


thanks & kind regars
 
A

Arvi Laanemets

Hi

What you got when you use
=IF(ISNA(VLOOKUP(B3,Data!$A$5:$B$97,2,FALSE)),0,VLOOKUP(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))
 
Top