Thread: #N/A
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default #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?