Dear All,

basically I have two questions, details in my excel sheet:
- why does my vlookup not work in the sheet
- how can I combine vlookup (or hlookup) with selected sums
ExplanationOfProblem.xlsx

it would be great if you could help me to solve this with a formula, rather than PIVOT or changing the layout a lot. there is quite a large original file and I have not many options to change the layout..

thanks a lot!

kind regards,
Sandra