#N/A

  • Thread starter Thread starter Fernando Duran
  • Start date Start date
F

Fernando Duran

I have this formula
=INDEX($C$3:$C$5000,MATCH(F21,IF($B$3:$B$500=F3,$A$3:$A$500),0))
when the cell is empty, give the display of #N/A, then, I just don't
get any additions.
There is any solution?
 
Hi Frank

May be I'm doing something wrong

=IF(ISNA(INDEX($C$3:$C$5000,MATCH(F21,IF($B$3:$B$500=F3,$A$3:$A$500),0)),"",INDEX($C$3:$C$5000,MATCH(F21,IF($B$3:$B$500=F3,$A$3:$A$500),0))))

Check it and tell me, because I'm getting an error there.
 
Hi Fernado
what kind of error did you get. I think you have lost some parantheses.
Try (without testing on my side)
=IF(ISNA(INDEX($C$3:$C$5000,MATCH(F21,IF($B$3:$B$500=F3,$A$3:$A$500),0)
)),"",INDEX($C$3:$C$5000,MATCH(F21,IF($B$3:$B$500=F3,$A$3:$A$500),0))))

HTH
Frank
 
Back
Top