#N/A
 

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?

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

#N/A
 

Hi Frank

May be I'm doing something wrong

=IF(ISNA(INDEX($C$3:$C$5000,MATCH(F21,IF($B$3:$B$5 00=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.

On Thu, 29 Jan 2004 15:21:18 +0100, "Frank Kabel"
wrote:

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?

#N/A
 

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$5 00=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

Fernando Duran wrote:
Hi Frank

May be I'm doing something wrong


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

Check it and tell me, because I'm getting an error there.

On Thu, 29 Jan 2004 15:21:18 +0100, "Frank Kabel"
wrote:

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?

#N/A
 

Hi Frank,

Works fine, just a little error, easy to detect.. thanks

Fernando
On Thu, 29 Jan 2004 16:48:29 +0100, "Frank Kabel"
wrote:

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

Fernando Duran wrote:
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.

On Thu, 29 Jan 2004 15:21:18 +0100, "Frank Kabel"
wrote:

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?