look up for value is one sheet and copy whole row in another sheet

hi

i need the following formula

Search the text of cell B4 of sheet B(it's a dropdown menu where you can choose different texts) in Sheet A in cells A8 till A12 and copy the row from colum B to cell A9 in sheet B

kind regards

In A9 of Sheet B, try this:

=INDEX('Sheet A'!B$8:B$11,MATCH($B$4,'Sheet A'!$A$8:$A$11,0))

Drag to the right.