| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
#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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
#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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
#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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
#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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
