Skip to Content
Former Member
Jun 04, 2010 at 04:56 PM

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


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.



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