VLOOKUP Problem - Need Very Difficult Function I need!

Hello folks,

I have come to the limit of my Excel knowledge.
Here is my table and the file to this:
QmfV5.jpg
testexcel.xlsx

I have a list with categories and subcategories.
Unfortunately some subcategories have the same name, even when they have different ParentCategories.n haben.

f.e. Software -> Zubehör (Extras), Server -> Zubehör (Extras).

Here I have a list (Column 4 and 5) and in the left column (Column 4) are the Parent Categories and in the right column (column5) are the Subcategories.

Now I want to assign at every subcategory the right categories ID from column 3. But because some subcategories have the same name, slookup doesn't work as I want it to work, because it shows always the ID with the same name.

Is there any way to solve this problem (automatic assignment of the ID to subcategories with same name) in Excel?

The solution to this problem is very important to me, therefore I appreciate any possible solution.

Kind regards,
George

Edit1: Put the Excel-File under the image

it is impossible to modify or add formulas to a picture. please upload a sample workbook, showing your data (all sensitive info removed), some examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

see if the attached is what you want? i added 2 helper columns, highlighted in yellow to assist with the extract, you can hide them if you want