0
How can I create a drop-down item list and when I select an item I want to display its cost in the next cell according to a set range of values?
Wiki User
∙ 13y ago
Create your list on your worksheet away from where you want the results. Include the values (cost) in the next column.
In the cell where you want the drop down list click data/validation and under 'allow' select list. Under 'source' highlight the range that contains your item list (do not include the values). Click OK.
When you select the cell you will now have the drop-down item list that you want. In the next cell you can use the VLOOKUP function to find the item chosen from the drop down list and return the cost
eg =VLOOKUP(A1,F1:G10,2)
assumes your drop down list is in A1, the item list is in the range F1:F10 and the cost is in G1:G10
Hope this helps
Al
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
How do you create a query that will display the top five orders in descending order by order total?
To create a query that will display the top five orders in descending order by order total create a select query object. Open the query design table and select the top five orders, then choose to display them in descending order.
What happens if you click on a word in a dropdown menu?
select whole word
Where can you see the list of the 2009 Emmy Awards winners?
You can get them here - http://www.emmys.com/nominations Use the dropdown to select the categories.
How do you make a fan page of Facebook?
1. Go to facebook.com/pages/create.2. Click to choose a Page category.3. Select a more specific category from the dropdown menu and fill out the required information.4. Click Get Started and follow the on-screen instructions.
How do you safe a notepad so you can continue your work in HTML later?
Go to save, then save as "Nameofpage.html" on the dropdown box underneath this select "All files"
How can you delete one item off a fire fox toolbar?
Simply right click on the item you want to remove and select Delete from the dropdown menu.
How do you find the version of redhat?
goto 'system' tab > in dropdown menu select 'about this computer'. or type in terminal cat <space> /etc/redhat-release
Where is computer time zone located?
Assuming you're using windows: You right click on the time display on the bottom right of the screen. Then click "Adjust Date/Time". When the window pops up, click on the tab on the top of the window that says "Time Zone". Then you can select whatever timezone you want from the dropdown menu.
On 2003 PowerPoint how do you set a picture for your background?
Click the format tab at the top of the screen,select "background"click the dropdown arrowselect fill effectsclick the picture tabclick select pictureopen your picture and apply to slide
What is typing text?
It is the font you select to display the text.
What is type of text?
It is the font you select to display the text.
What allows users to save Excel worksheet in HTML format?
Open file menu and select SaveAs (choose "other format"). In the "Save as type" dropdown, select Web Page (*.htm,*.html).Websupport
