I don't know the correct terminology, so i don't know how to look up what I'm
wanting to do.

I'd like to type a key word into a cell that pulls in a set of numbers from
a second worksheet. Example, I might type the word Broccoli in Column A.
Data from Sheet2 would insert 1 ounce into Column B and the grams of protein,
fat and carbs into Columns C, D and E ... assuming the data were in the
respective columns on Sheet 2.

Could someone tell me how I could pull numbers from one sheet into another
by typing a single word? All I need is a running head start on the
terminology and maybe an example.