Creating a dashboard

Diskutiere Creating a dashboard im Office Forum im Bereich Microsoft Community Fragen; Hi, First post, so apologies if this is very or too basic. I'm trying to create a reporting dashboard, a small sample of which is below...

MSCom

Neuer Benutzer
Threadstarter
Dabei seit
20.09.2016
Beiträge
1
Hi,

First post, so apologies if this is very or too basic.

I'm trying to create a reporting dashboard, a small sample of which is below.

I want to be able to change the fields in B2 to E2 in order to get the results in B5 to E6. I'm trying to use INDEX with MATCH (which might not be the best way I guess) but I get a #REF! error. This happens when I add a second MATCH criteria.

You may have noticed I am using a German keypad by the ";" instead of a comma but my formulas are set to English. Problem perhaps?

The example formula in C5 is =INDEX(F11:F22;MATCH(B2;B11:B22;0);MATCH(C2;C11:C22;0))

I've also tried, from searching on Google, to do simpler formulas with INDEX & MATCH but even when I follow the formula exactly, it doesn't work.

Can anyone help?
Mike
 
#
schau mal hier: Creating a dashboard. Dort wird jeder fündig!
Registrieren bzw. einloggen, um diese und auch andere Anzeigen zu deaktivieren
Thema:

Creating a dashboard

Creating a dashboard - Ähnliche Themen

"Access to the resource is forbidden" error while trying to import data from Sharepoint.: I am trying to import data from a file in SharePoint via "Get Data" - "From File" - "From Sharepoint Folder" in Excel. I have created the file...
How to condition formula on other cell content: Hi, I am not sure how else to phrase my request and hope someone can help me. I created an expense list for my project and am constantly...
Excel: Flash Fill not exact: Hi, I am using Flash Fill in order to separate Names for sample: Nicole Nice Minni Magic ... Now I have names with doubled name or with...
Using Vlookup on other Workbook whichs path is stored in a Cell: Good Day Im Trying to do Vlookup on a closed Workbook whichs path is stored in a Cell. For that im writing a Function which opens the Workbook...
Share to Outlook: Hi everyone, I am using DRAWBOARD PDF on my new SURFACE PRO7, and want to SHARE a PDF to OUTLOOK. Unfortunatly it is only possible to share...
Oben