0
Based on the discussion, here is what the person who asked the question wants answered.
Given:
A3:A7 --> Recipe Titles
B3:B7 --> Corresponding Recipe Ingredients
Add:
D3 --> Set Data Validation to list of items in A3:A7 (create drop-down list of recipes)
E3 --> =VLOOKUP(D3,A3:B7,2,A3:A7)
When you select a recipe from the drop-down list in D3, you will see the list of ingredients in E3.
BONUS SECTION:
In Excel 2007, on the Data Tab, click on the Data Validation icon in the Data Tools section. In the Data Validation Window, on the Settings tab, select an Allow option of List. Select the list of A3:A7 and click OK.
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
What are the primary functions of Word Excel and Powerpoint?
The primary function of Word is to create documents, Power point is to create slides. Excel can be used for calculations and tables.
What is the difference between Microsoft Word and MS Excel?
Word: Is used to Create / Edit Word Processing documents Excel: Is used to Create / Edit Spreadsheet Calculations Hope this helps
Creating an .csv file from word?
create a Word table, Select the entire table and Copy, paste into an Excel doc, save Excel doc as .csv
How do you do a math problem on Microsoft Word?
With Microsoft Excel, you can solve math problems (basic and scientific) and use and create graphs. If you have Word, than you should have Excel.
Describe in which situation you will use word processing spreadsheets and PowerPoint?
MS Word (word processing) - Create a letter. MS Excel (spreadsheet) - Create a budget. MS PowerPoint - Create a briefing.
What would you use as a word processor or to create spreadsheets?
Microsoft Word would be for creating word processing documents and Microsoft Excel would be used to create spreadsheets.
What is Microsoft execel?
MS stands for Microsoft so ms word and ms excel are Microsoft Word and Microsoft Excel respectively. We can create documents in windows operating system with usually MS Word used to create word documents and MS excel for creating spreadsheet for calculation etc.
Why do you use microsoft office?
MS Office is an office suite that contains Word, Excel, PowerPoint and many more. I use it for following reasons: To create document- for this I use MS Word To create spreadsheet- for this I use MS Excel To create presentation- for this I use MS PowerPoint
Will MS Excel will it create memos?
Excel is not generally used for creating memos, but you could use it to do so. You are more likely to use a word processor, like Microsoft Word.
What applications would be the best choice to create a resume Excel or Word?
Microsoft Word should be the best choice to create a Resume. It is because it does not need pictures or Graphs.
What option do you select when you want to insert the entire contents of a Word file into Excel?
Create from File
Which tab on the ribbon do to use to create a chart?
In both micro. excel and word its on the insert tab!
