looking for Jean Marc Voyer

[DDOC]

Hello I am trying to locate Jean Marc Voyer, he created a dashboard for a contest here a few years ago that I desire to utilize and need some guidance.

 

[NARAYANK991]

Hi ,

If you mean the salary survey dashboard , why don't you post a link to the dashboard here , and then ask your questions ?

Someone or the other can help.

Narayan

 

[DDOC]

Narayan,

Not that one, the one I'm speaking of is the one for population migration.

 

[NARAYANK991]

Hi ,

The idea remains the same ; post the link to the dashboard , if that is possible.

Narayan

 

[DDOC]

Narayan,

It's the Migration Dashboard by Jean-MarcVoyer on this link.
http://chandoo.org/wp/2014/06/12/state-migration-dashboard-contest-entries/

 

[NARAYANK991]

Hi ,

Please post your questions / doubts.

Narayan

 

[DDOC]

on the DATA1 the "State Selected" shows [CELLRANGE] but there is an #N/A error message stating "A value is not available to the formula or function" =VLOOKUP(K172,$J$183:$K$236,2,0) that's the formula but I don't understand whats missing. If it is correct the state abbreviations on the dashboard will show on their perspective locations but right now it is not.

I think I may have found the issue, a COM add-in is not being allowed to run on my system. Firewall security issue

 

[NARAYANK991]

Hi ,

The CellRange object is available only in Excel 2013 and later versions.

What version of Excel are you using ?

Narayan

 

[DDOC]

GOTCHA!!! I am running 2013 on my home system and 2010 at work.