jsam050274
New Member
- Joined
- Jul 17, 2008
- Messages
- 2
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
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