Dashboards - error

[ProSpeaker]

Greetings all,

I'm working on creating a dashboard. I currently have 3 worksheets, the report or mock up page, a control sheet and my first data sheet. The data sheet has fields that will be looking at the control sheet for the current month (CurMonth) and then going to an Excel database of information and returning a figure for that cell. I'm getting an error #NA and it's driving me crazy.

I'm using the following to pull this information in: =MATCH(CurMonth,ActGL.xls!Date,0), but it is retrieving the #NA.

I'm able to email the brief workbook to have someone look at it. I'm trying to make a grad school project look nice.

Any help would be greatly appreciated.

Regards,
-W

 

[Jonmo1]

=if(isna(MATCH(CurMonth,ActGL.xls!Date,0))=TRUE,"",MATCH(CurMonth,ActGL.xls!Date,0))

You can insert text or a number between the quotes to make it display something else instead of #N/A.

 

[ProSpeaker]

Dashboards - Error

Thanks JonMo1,

However, I'm attempting to determine why it's not returning the value that it is suppose to return for that cell.

I'll keep that if statement for future reference.

Thanks,
-W

 

[Jonmo1]

formulas return #N/A because it didn't find the value it was looking for. check your source data for Formatting differences. Also look for and remove extra spaces and other characters like ' * etc. in text strings.

 

[ProSpeaker]

Dashboards - Error

Thanks!