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
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
Troubleshooting: Issue with MFA Using YubiKey without a Mobile Phone Troubleshooting: Issue with MFA Using YubiKey without a Mobile Phone: Hello everyone,I hope this email finds you well. I am writing to seek assistance regarding an issue I am currently facing with the Multi-Factor Authentication MFA process using YubiKey. I have...	Microsoft Office	12. Juli 2023
Syncing problem using rules Syncing problem using rules: Hey,I hope someone outhere can help me to figure out Outlook for Windows.I have two mailboxes, lets call them A: * Die E-Mail-Adresse wurde aus Datenschutzgründen entfernt. * and B: *** Die...	Outlook.com	13. Oktober 2022
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

Creating a Custom Bibliography and Citation

Troubleshooting: Issue with MFA Using YubiKey without a Mobile Phone

Syncing problem using rules

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