Recalling Info Into Another Row

I am trying to recall info from the rows in another part of a worksheet when I type the first column. For example, I have over 300 rows of:

Apples 155 12oz red
Orange 120 10oz orange
Banana 50 11oz yellow
etc.

I want to select or type only the word:

Apples

And have the rest of the columns fill in with the rest of the info, like so:

Apples 155 12oz red

A filter would work well to select, except I need about 7 in the worksheet as it is a form and excel only allows one. I can’t seem to make the advanced filter work. An IF function would work, except I'd have to put all the words to match in " " marks, which would be very time consuming.

how I can recall the info from my list to the 7 lines I need to copy them into?