Match, Index and Vlookup all show as #N/A but work in Excel?

Hi Folks,

I'm really banging my head against the wall here.

I have been trying to do a crosstab format for a stacked column chart on a dashboard. I'm trying all sorts of combinations and no matter what I do the result shows up as N/A (though it works in the Excel model when exported).

=MATCH(BY7,$BW$7:$BW$158,0) where BY7 is a hardcoded value

=MATCH($CC$6&CB7,$BW$7:$BW$158,0)

nothing works

what's most irritating though is I have a dashboard doing nearly the exact same thing and it does work.

Any ideas?

Also, how am I suposed to populate crosstab style tables in Xcelsius for stacked column charts ifvlookup/match/index are not recommended? Any advice gratefully received.

Thanks,

Jeanne

Edited by: Jeanne Chapple on Jun 4, 2010 7:04 PM