Excell hlookup

I have multiple criteria and multiple sheets using

This returns a error 512 - can anyone help ?
many thanks in advance.

Please give a specific example of the criteria and desired results. Also, the title and tags are not good. This is not an MS Office forum. Are you asking about LibreOffice Calc? See guidelines for asking.

You used curly brackets where ordinary parentheses are needed.
The culy brackets around formulas enclose everything (including the =) and must not be entered, but are generated for display when the formula is entered for array-evaluation by Ctrl+Shift+Enter.

And you cannot do a horizontal lookup in a vertical array.

Where did you get that flim-flam from?