Google Sheets search and select from Database

Question

i'm trying to make a advanced search but i'm stuck at all. I tried it with =SVERWEIS and also with INDEX but failed.

I hope the doc explains enough what I wanna try to do but failed at all. My knowlege isn't that bad but here I need help. Would be nice if someone could help me with this.

https://docs.google.com/spreadsheets/d/1BGFzntBg-YHcRHM0qChFg9yoLahoOTUehoV3_9DY9PU/edit?usp=sharing

This is the doc and can be edited.

Thanks for your time reading my bad english post. :)

https://prnt.sc/t7c85l

Answer 1

use:

=ARRAYFORMULA(VLOOKUP(A3:A; D:H; MATCH(B2; D2:H2; 0); 0))

spreadsheet demo