N/A Error

[jsam050274]

Hi,

I have the following formula in a workbook. This pulls data from a small table into a larger table. I am getting N/A errors when the date is not showing in the small table so in theory there is nothing to pick up. Can someone help me to get rid of these, ideally return a "0".

=INDEX($C$62:$W$101,MATCH($A7,$A$62:$A$101,1),MATCH(C$6,$C$61:$W$61,0))


Kind Regards

John

 

[Aladin Akyurek]

On Excel 2007...

=IFERROR(
  INDEX($C$62:$W$101,MATCH($A7,$A$62:$A$101,1),
     MATCH(C$6,$C$61:$W$61,0)),0)

Otherwise:

=LOOKUP(9.99999999999999E+307,CHOOSE({1,2},
  0,
  INDEX($C$62:$W$101,MATCH($A7,$A$62:$A$101,1),
     MATCH(C$6,$C$61:$W$61,0))))

Hi,

I have the following formula in a workbook. This pulls data from a small table into a larger table. I am getting N/A errors when the date is not showing in the small table so in theory there is nothing to pick up. Can someone help me to get rid of these, ideally return a "0".

=INDEX($C$62:$W$101,MATCH($A7,$A$62:$A$101,1),MATCH(C$6,$C$61:$W$61,0))


Kind Regards

John

 

[jsam050274]

Many Thanks,

I used the first option and all is fine.

Many Thanks again for the help,

Regards

John