Comes up #n/a, what do I do?

[Anthony]

Use the following formula to draw data from a table back to a spreadsheet,
however the formula applies for 20 cells down a page, how do i stop #n/a
appearing for those cells not yet inputed

=INDEX('Cattle prices'!$B$4:'Cattle prices'!$AW$18,MATCH(B76,'Cattle
prices'!$A$4:'Cattle prices'!$A$18,0),MATCH('Cattle Mvts'!E76,'Cattle
prices'!$B$3:'Cattle prices'!$AW$3,0))

thanks ant

[Anne Troy]

=if(isblank(a1),"",yourformula here
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Anthony" <Anthony@discussions.microsoft.com> wrote in message
news:BD9EE6B0-8A4D-4261-AFB9-3DEA6078421E@microsoft.com...
> Use the following formula to draw data from a table back to a spreadsheet,
> however the formula applies for 20 cells down a page, how do i stop #n/a
> appearing for those cells not yet inputed
>
> =INDEX('Cattle prices'!$B$4:'Cattle prices'!$AW$18,MATCH(B76,'Cattle
> prices'!$A$4:'Cattle prices'!$A$18,0),MATCH('Cattle Mvts'!E76,'Cattle
> prices'!$B$3:'Cattle prices'!$AW$3,0))
>
> thanks ant

[Anthony]

Thanks anne

works a treat

"Anne Troy" wrote:

> =if(isblank(a1),"",yourformula here
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> "Anthony" <Anthony@discussions.microsoft.com> wrote in message
> news:BD9EE6B0-8A4D-4261-AFB9-3DEA6078421E@microsoft.com...
> > Use the following formula to draw data from a table back to a spreadsheet,
> > however the formula applies for 20 cells down a page, how do i stop #n/a
> > appearing for those cells not yet inputed
> >
> > =INDEX('Cattle prices'!$B$4:'Cattle prices'!$AW$18,MATCH(B76,'Cattle
> > prices'!$A$4:'Cattle prices'!$A$18,0),MATCH('Cattle Mvts'!E76,'Cattle
> > prices'!$B$3:'Cattle prices'!$AW$3,0))
> >
> > thanks ant
>
>
>