#N/A

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?
 
F

Frank Kabel

Hi Fernando
replace your formula with
=IF(ISNA(INDEX(....),"",INDEX())

HTH
Frank
 
F

Fernando Duran

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.
 
F

Frank Kabel

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
 
Top