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?
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
What else can I help you with?
What happens if you click on a word in a dropdown menu?
select whole word
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.
How to display only photos without keywords in Lightroom?
To display only photos without keywords in Lightroom, you can use the Library Filter Bar. Click on the Metadata option and then select the option "Keywords" from the dropdown menu. From there, you can choose to filter out photos that do not have any keywords assigned to them.
How can I create a Scrum board in Jira?
To create a Scrum board in Jira, follow these steps: Log in to your Jira account. Go to the project where you want to create the Scrum board. Click on the "Boards" dropdown menu and select "View all boards." Click on the "Create board" button. Choose the option to create a Scrum board. Select the project and board name. Customize the board settings as needed. Click on the "Create" button to create your Scrum board in Jira.
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 to create a Scrum board in Jira?
To create a Scrum board in Jira, follow these steps: Log in to your Jira account. Go to the project where you want to create the Scrum board. Click on the "" icon and select "Board" from the dropdown menu. Choose the option for a Scrum board. Customize the board settings according to your project needs. Add the necessary columns, swimlanes, and filters to organize your tasks. Save the board and start using it to manage your Scrum project.
When A program requires that you change your screen size from 1024 X 728 to 800 X 600 in locations should make this change?
To change your screen size from 1024x728 to 800x600, you can adjust the display settings on your computer. On Windows, right-click on the desktop, select "Display settings," and choose the desired resolution from the dropdown menu. On macOS, go to "System Preferences," then "Displays," and select the appropriate resolution. After making the change, ensure to apply and confirm the new settings.
How Do I Change My Screen Size From 1024 X 728 to 800 X 600?
To change your screen size from 1024 x 728 to 800 x 600, right-click on the desktop and select "Display settings" (on Windows) or "System Preferences" followed by "Displays" (on macOS). In the display settings menu, look for the resolution dropdown and select 800 x 600. After making your selection, click "Apply" or "OK" to confirm the changes. Your screen should now adjust to the new resolution.
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 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
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"
