#N/A
Hi Fernando
replace your formula with
=IF(ISNA(INDEX(....),"",INDEX())
HTH
Frank
Fernando Duran wrote:
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?
|