How to use advanced criteria

shadrack,

Welcome to the forum!
Attached is a modified version of your posted workbook.

It is important to note that all three of the following formulas are array formulas. Array formulas must be entered with Ctrl+Shift+Enter and not just Enter. That is how they get the curly braces {} around them. Don't try to add those manually.

In 'Print_Factuur' cell A31 and copied down is this array formula:

Please Login or Register  to view this content.

In 'Print_Factuur' cell I31 and copied down is this array formula:

Please Login or Register  to view this content.

In 'Print_Factuur' cell K31 and copied down is this array formula:

Please Login or Register  to view this content.

[EDIT]
I should also add that the formula is supposed to be multiple lines. This is because in your table, the field for "FactuurNummer" actually has a carriage return character (char 10) in the middle. This causes the formula to be required to be written with the carriage return (alt+enter, though you should be able to copy and paste the formulas above).

You're very welcome


How to mark a thread Solved:

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save