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.
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