|
|
Thanks anne
works a treat
"Anne Troy" wrote:
=if(isblank(a1),"",yourformula here
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"Anthony" wrote in message
...
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
|