Multicriteria lookup with excluding data

[Magneticz]

Hello,

this is my very first thread. I have never thought I can post something like this but I am stuck in circles. I want to ask for help with my current case. I tried Index Match function but no success. The biggest problem for me is to say lookup in ALL or Exclude something.

I have a report and only what I need is to do a mapping of categories. For mapping I have a condition matrix. The goal is to assign a category from first column based on Type/Account/Memo.

1. For accounts is common condition ALL accounts (means really all from the system so ANY OF) except some of them which we need to exclude from lookup. (A)
2. Or -> the account is specifically given like this account "3000" and payment type is Invoice (D)
3. Or again -> this could be All accounts for some Type but condition for Memo must be meet as well


Condition list
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Category[/TD]
[TD]Type[/TD]
[TD]Account[/TD]
[TD]Except Account (excluding)[/TD]
[TD]Memo[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Invoice[/TD]
[TD]ALL[/TD]
[TD]2000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Invoice[/TD]
[TD]ALL[/TD]
[TD]2500[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]Invoice[/TD]
[TD]3000[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Journal[/TD]
[TD]1000[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Bill[/TD]
[TD]ALL[/TD]
[TD][/TD]
[TD]+TRF[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]Bill[/TD]
[TD]4000[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


It would be great if you can show me the light on the end of tunnel

many thanks for any advice and tries.
Cheers,
Tomas