Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Comes up #n/a, what do I do?
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|