im trying to simplify my SS with 1 formula instead of what im doing in cols C, D and E with formulas in every row

basically on my example i get data to col B from Derivative sheet on source SS and need to get data to cols C, D and E from Instruments sheet

where Instruments!B:B = Derivatives!B:B - link between those 2 sheets

it should be something like INNER JOIN with SQL, so i tried with query, match, vlookup and couldnt do it, probably cos my lack of skills