VLOOKUP function for a database with hierarchy structure?

Hello everyone,

Please see yellow banner on how to attach a sample workbook. Be sure to show an example of how you require the output formatted

As John has said sight of the workbook and the results you expect to see is vital to understand the end goal.

That said I suggest your database is compromised. Instead of the last three columns Position 1, 2 & 3 you'd be better having the 8th column labelled 'Position' and in the column record the position numbers 1,2,3...etc.
Then in the 9th column the Materialnummer, K1, B1, ....etc

It will of course require three rows for Materialnummer B1, and two rows for B2, where columns 1-7 contain the same values, but it does mean that you have a normalised 2 dimensional database which can be used by a Pivot Table.