Problem with creating a new Page using Ctrl + K in OneNote

BraJean · 26. Oktober 2024

Hey there,since I've been struggling to figure out the issue for a while now, I've decided to just ask here. I'm at a loss and it's driving me up the wall.I use links in my pages a lot to keep organized and to keep information connected. I'm in uni and being able to just link to a definition or a more in-depth explanation has helped me immensely. It also helps me to organize my notes by having a Register Page where I can check off all the chapters I have worked through, with links to the chapters letting me just skip ahead to it.I've recently switched PCs and double checked all settings, so th

Mike the Lord

And breathe!!! Thank you so much Claus. This has worked. Most grateful.

Mike

Mike the Lord

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

Guess a snippet wasn't the right Thing to send. Column B is "Market"

[table][tr][td]Market[/td][td]Brand[/td][td]Month[/td][td]Year[/td][td][td][td]Market [/td][td]Product[/td][td]Month[/td][td]Year[/td][/tr][tr][td]USA[/td][td]Pears[/td][td]January[/td][td]2018[/td][td][td][td]USA[/td][td]Apples[/td][td]January[/td][td]2017[/td][/tr][tr][td]Mike's Fruit Market[/td][td][td][td]Germany[/td][td]Pears[/td][td]February[/td][td]2018[/td][/tr][tr][td]Year[/td][td]Sales[/td][td]Revenue[/td][td]GP[/td][td][td][td]France[/td][td]Oranges[/td][td]March[/td][td][/tr][tr][td]2018[/td][td]#REF![/td][td] [/td][td] [/td][td][td][td]UK[/td][td]Bananas[/td][td]April[/td][td][/tr][tr][td]2017[/td][td] [/td][td] [/td][td] [/td][td][td][td][td][td]May[/td][td][/tr][tr][td]+/-[/td][td]#REF![/td][td] [/td][td] [/td][td][td][td][td][td]June[/td][td][/tr][tr][td]#REF![/td][td] [/td][td][td][td][td][td]July[/td][td][/tr][tr][td][td][td][td][td][td][td][td][td]August[/td][td][/tr][tr][td]Market[/td][td]Brand[/td][td]Month[/td][td]Year[/td][td]Sales[/td][td]Revenue[/td][td]GP[/td][td][td]September[/td][td][/tr][tr][td]USA[/td][td]Apples[/td][td]January[/td][td]2017[/td][td] 4.000 [/td][td] 2.000 [/td][td] 1.200 [/td][td][td]October[/td][td][/tr][tr][td]Germany[/td][td]Oranges[/td][td]February[/td][td]2018[/td][td] 4.111 [/td][td] 2.056 [/td][td] 1.233 [/td][td][td]November[/td][td][/tr][tr][td]France[/td][td]Pears[/td][td]April[/td][td]2018[/td][td] 3.350 [/td][td] 1.675 [/td][td] 1.005 [/td][td][td]December[/td][td][/tr][tr][td]Germany[/td][td]Apples[/td][td]February[/td][td]2017[/td][td] 2.005 [/td][td] 1.003 [/td][td] 602 [/td][td][td][td][/tr][tr][td]France[/td][td]Pears[/td][td]March[/td][td]2017[/td][td] 1.761 [/td][td] 881 [/td][td] 528 [/td][td][td][td][/tr][tr][td]UK[/td][td]Bananas[/td][td]January[/td][td]2017[/td][td] 1.070 [/td][td] 535 [/td][td] 321 [/td][td][td][td][/tr][tr][td]USA[/td][td]Apples[/td][td]April[/td][td]2018[/td][td] 412 [/td][td] 206 [/td][td] 124 [/td][td][td][td][/tr][tr][td]UK[/td][td]Bananas[/td][td]March[/td][td]2018[/td][td] 247 [/td][td] 123 [/td][td] 74 [/td][td][td][td][/tr][tr][td]France[/td][td]Oranges[/td][td]April[/td][td]2018[/td][td] 905 [/td][td] 453 [/td][td] 272 [/td][td][td][td][/tr][tr][td]UK[/td][td]Apples[/td][td]February[/td][td]2017[/td][td] 1.563 [/td][td] 782 [/td][td] 469 [/td][td][td][td][/tr][tr][td]USA[/td][td]Pears[/td][td]January[/td][td]2017[/td][td] 2.222 [/td][td] 1.111 [/td][td] 667 [/td][td][td][td][/tr][tr][td]Germany[/td][td]Apples[/td][td]February[/td][td]2018[/td][td] 2.880 [/td][td] 1.440 [/td][td] 864 [/td][td][td][td][/tr][/table]

Claus Busch

Hi Mike,

I guess that's a problem with the separators or the region settings.

Download the workbook from here:

https://1drv.ms/x/s!AqMiGBK2qniTgeEVfCRQpMU7LlW_ow

When you open it on your machine the formulas should be translated to your settings.

Claus

Claus Busch

Hallo,

oder einfacher in C5 mit:

=SUMIFS($F$11:$F$22,$B$11:$B$22,$B$2,$C$11:$C$22,$C$2,$E$11:$E$22,B5)

Claus

Claus Busch

Hallo,

du musst B2 und C2 in einem Schritt vergleichen. Probiere:

=INDEX(F11:F22,MATCH(B2&C2,B11:B22&C11:C22,0))

und schließe die Eingabe der Formel mit STRG+Shift+Enter ab (Array-Formel).

Claus

Hi,

willkommen im Windows Forum!

Problem with creating a new Page using Ctrl + K in OneNote - Similar Threads - Problem with creating	Forum	Datum
Problem with using OneDrive in Ubuntu/Gnome Problem with using OneDrive in Ubuntu/Gnome: Hey,I want to add my Microsoft account to the Online Accounts section in Ubuntu so I can access my OneDrive files through the Files app. It worked yesterday when I added my Microsoft account for...	Microsoft Office	6. Juli 2025
Unwanted spacing upon creating Outlook email with Python Unwanted spacing upon creating Outlook email with Python: Hello,at the end of a workflow I am automatically creating an outlook mail to inform selected co-workers.Unfortunately, when creating an HTML Body the Before and After spacing values seem to be...	Outlook.com	4. November 2024
Creating a Custom Bibliography and Citation Creating a Custom Bibliography and Citation: Hello Guys and Girls,I used this Guide. And in there it says after saving it should show up in Style: drop down in the references tab but it wont in my casei have win11 and word2019 installed	Microsoft Office	10. April 2024
Is there a way to number OneNote pages similar to Word with a function or a plugin? e.g. 1,... Is there a way to number OneNote pages similar to Word with a function or a plugin? e.g. 1,...: I would like to organise my pages by numbering them but doing it manually is a bit of a pain everytime I change something.	Microsoft Office	20. Oktober 2021
SharePoint adds special characters when creating a page SharePoint adds special characters when creating a page: Hi Commuity, i have another wired issue. When creating a page, sharepoint sometimes adds ",#" before a department name drop down menu. It is rare but it happens. Does anyone know a solution?...	Microsoft Office	14. April 2021
WORD macro unlink all fields. Problem with page numbers WORD macro unlink all fields. Problem with page numbers: Hi I want to unlink all fields in a word document with a macro. It works with the following VBA code. But when I have page numbers multiple pages in a document the numbers will just show "1" on...	Microsoft Office	1. Dezember 2020
Creating a dashboard Creating a dashboard: 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...	Microsoft Office	25. Januar 2019

Problem with creating a new Page using Ctrl + K in OneNote

Problem with creating a new Page using Ctrl + K in OneNote

Creating a dashboard

Creating a dashboard

Creating a dashboard

Creating a dashboard

Creating a dashboard

User Advert

Problem with creating a new Page using Ctrl + K in OneNote - Microsoft Office

Problem with creating a new Page using Ctrl + K in OneNote - Similar Threads - Problem with creating

Problem with using OneDrive in Ubuntu/Gnome

Unwanted spacing upon creating Outlook email with Python

Creating a Custom Bibliography and Citation

Is there a way to number OneNote pages similar to Word with a function or a plugin? e.g. 1,...

SharePoint adds special characters when creating a page

WORD macro unlink all fields. Problem with page numbers

Creating a dashboard

Problem with creating a new Page using Ctrl + K in OneNote solved