Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look-Up Capability
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look-Up Capability
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 Tampa-Terry wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look-Up Capability
Dave, thank you for the lead!!! That sounds like EXACTLY what I was looking
for. I appreciate the link to Debra's site, too!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expanding text capability | Excel Discussion (Misc queries) | |||
Timeout-Lockout capability | Excel Discussion (Misc queries) | |||
Conditional formatting capability for 20+ conditions not just 3. | Excel Discussion (Misc queries) | |||
Add capability to graph in the form of y=x. | Charts and Charting in Excel | |||
Add capability to graph in the form of y=x. | Charts and Charting in Excel |