Home Page Knowledge Base Support Forum Free Downloads

VLOOKUP & the Dashboard Widgets

Please post your comments related to configuring the ExcelDashboardWidgets spreadsheets here.

Moderator: DashboardWidgets

VLOOKUP & the Dashboard Widgets

Postby GregEmerson » Tue Dec 03, 2013 6:21 pm

Can the widgets be linked to a VLOOKUP? This would be very helpful in being able to visualize forecast data.

BR/
Greg Emerson
GregEmerson
 
Posts: 4
Joined: Tue Dec 03, 2013 6:04 pm

Re: VLOOKUP & the Dashboard Widgets

Postby DashboardWidgets » Wed Dec 04, 2013 10:15 am

Hi Greg

Take a look at the Health Facility Dashboard example here...

viewtopic.php?f=24&t=98

Health Facility.jpg

On the third tab (entitled 'My Database') you can see that the main dashboard pulls in data from a larger database using an Excel lookup function (take a look at the code in the yellow cells).

We don't actually use VLOOKUP, we use INDEX MATCH but the principle is the same.

Hope this helps get your head around how the dashboard works.

Please get back to us if you have more questions.

Cheers

DashboardWidgets
DashboardWidgets
 
Posts: 332
Joined: Mon May 30, 2011 7:06 pm

Re: VLOOKUP & the Dashboard Widgets

Postby GregEmerson » Wed Dec 04, 2013 6:28 pm

Thanks for the response. I will try to nuke somethoing out, for the up/down arrows, which is what I was interested in using the look-up with.

Cheers,
Greg
GregEmerson
 
Posts: 4
Joined: Tue Dec 03, 2013 6:04 pm

Re: VLOOKUP & the Dashboard Widgets

Postby DashboardWidgets » Thu Dec 05, 2013 11:25 am

Hi Greg

If you can describe what you are trying to do we'll also try and pull together a quick example for you using the UP/ DOWN widget and VLOOKUP (and we could even make a video screencast).

Good luck!

DashboardWidgets
DashboardWidgets
 
Posts: 332
Joined: Mon May 30, 2011 7:06 pm

Re: VLOOKUP & the Dashboard Widgets

Postby GregEmerson » Thu Dec 05, 2013 2:50 pm

Hi everyone,
I was hoping to visualize data from a forecasting model in three areas: Office Workstations, Headcount and Office squarefootage. My company is looking at building needs over the next five-years for approx. 20 locations across the US. I have a spreadsheet that I was hoping to use the up/down to show the location and year in each of the three areas, to visualize the increase or decrase and it's trend percentage. Contact me at my email address and i can supply you with an example for the video screencast.

Cheers,
Greg
GregEmerson
 
Posts: 4
Joined: Tue Dec 03, 2013 6:04 pm

Re: VLOOKUP & the Dashboard Widgets

Postby DashboardWidgets » Thu Dec 05, 2013 10:44 pm

Hi Greg

Thanks for your reply.

If you can provide us with some raw data for Office Workstations, Headcount and Office Square Footage we would be happy to put together a tutorial explaining how to configure an UP/DOWN type dashboard to communicate this information in a clear and functional way.

Just for your information, our policy is to keep communication via the forum rather via email - the logic being that everyone gets an opportunity to learn from the tutorial examples that are posted here.

Warmest regards

DashboardWidgets
DashboardWidgets
 
Posts: 332
Joined: Mon May 30, 2011 7:06 pm

Re: VLOOKUP & the Dashboard Widgets

Postby orlaward » Fri Jun 22, 2018 9:30 am

Hi,

I want to use Data validation and V Look up so that when I pick a date from a drop down menu it automatically updates the dails with information from that date? Is there a video that shows this please?

Thank you
orlaward
 
Posts: 2
Joined: Fri Jun 08, 2018 7:43 am


Return to 1. Configuring the Spreadsheets



Who is online

Users browsing this forum: No registered users and 1 guest

cron