View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Amin Amin is offline
external usenet poster
 
Posts: 48
Default referencing in tables

hi i have a sheet that contains a column with dates from jan to dec which i
have also formated as a table. i have a sheet also formatted as tables
representing the 12 months, but in this 2nd sheet the mothns are sprated by 3
merged rows and i want to get the dates enterd in the date sheets to refelect
in the second sheet. it does happen when i use =and select the the sheet tab.
all i want know is how can i get it so that when there is no date it will not
show a zero zero but N/A or nothing