I have an excel sheet and I am have certin bits of information looked up from
a chart. For example, I would have a chart with totals from 2006, 2007, 2008.
The following line of code selets the total form 2006. It works fine.
However, when there is no value, #n/A is displayed. I know how to tell the
indiviual cell to display somethings. When I but it into code, i receive a
syntax error and the recorder does not work with this. How should the syntax
be?


Functional in excel sheet:
=IF(ISNA(OFFSET(A28,MATCH("TOTAL",A29:A143,0),MATC H(2006,A27:S27,0)-1,1,1)),"There
is no value for this year",(OFFSET(A28,MATCH("TOTAL",
A29:A143,0),MATCH(2007,A27:S27,0)-1,1,1)))

Who can I enter this information into VBA without getting a syntax error?