Look-Up Capability

[Guest]

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.

 

[Dave Peterson]

Maybe you could create a table with all the stuff you wanted (on that second
sheet).

Then use =vlookup() to retrieve the values you want.

Debra Dalgleish has lots of notes on =vlookup():
http://www.contextures.com/xlFunctions02.html

 

[Guest]

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