Excel Formula

[NaughtyPopz]

Hello,

Is there anyone that can help me please? Underneath is some kind of example, but the excel I'm working at is gigantic.
I want to make this excel dynamic, so I don't want to work with 100 if functions, but I don't know any other way to make this work, if this is even possible with a V / X lookup, or index match or some other formula?

In cell E2 I want to return a dropdown list with ArticleID based on previous selected criteria in cells C2 and D2.
Is this possible?

 

[Rhodie72]

I think you want to use VBA to achieve this as the complexity is much reduced with If function as code

If you would please post that sample data as a mini-sheet instead of an image then we can probably work something out.

If you don't know anything about VBA, don't worry. There are thousands of people on this forum who can help.

Press Alt+F11 and you're in the VBA Editor. That is where the code is written.
Although it's a learning curve, it is not too hard to get useful things done.
Start by recording a macro when viewing your Workbook.

To start and stop recording click this icon:

To run that macro you only need to press Alt+F8
To see what was recorded, press Alt+F11

whatever actions are caused by running a macro cannot be undone by clicking undo, ALWAYS WORK ON TEST DATA IN A DIFFERENT WORKBOOK until yo are sure that what you have is good working code