Look-Up Capability

T

Tampa-Terry

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.
 
T

Tampa-Terry

Dave, thank you for the lead!!! That sounds like EXACTLY what I was looking
for. I appreciate the link to Debra's site, too!!!
 
Top