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?
How do you select option 1 option 2 and option 3 I n excel?
In Excel, you can create a dropdown list to select from options 1, 2, and 3 using Data Validation. First, select the cell where you want the dropdown, go to the "Data" tab, and click on "Data Validation." In the dialog box, choose "List" from the "Allow" dropdown and enter "Option 1, Option 2, Option 3" in the "Source" field. This will allow you to select one of the options from the dropdown in that cell.
How do you change the refresh rate?
To change the refresh rate of your display, right-click on the desktop and select "Display settings." Scroll down and click on "Advanced display settings," then choose your display from the dropdown menu. Look for the "Refresh rate" option and select your desired rate from the available options. Finally, click "Apply" to confirm the changes.
What is ''properties from dropdown menu?
"Properties from dropdown menu" typically refers to a feature in software applications or user interfaces where users can select specific attributes or settings from a list that appears when they click on a dropdown menu. This allows for easier navigation and selection of options, such as adjusting settings, choosing file formats, or modifying display preferences. The dropdown menu consolidates multiple choices in a compact format, enhancing user experience by reducing clutter on the interface.
How to make a referd dop down menu in LibreOffice?
To create a referred dropdown menu in LibreOffice, first, select the cell where you want the dropdown. Then, go to the "Data" menu, choose "Validity," and in the dialog box, select "Criteria." Under "Allow," choose "List," and in the "Entries" field, enter your options separated by commas or reference a range of cells containing the list. Click "OK," and your dropdown menu will be created in the selected cell.
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
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.
What ribbon and button would you select to to create a PowerPoint hyperlink?
To create a hyperlink in PowerPoint, you would select the "Insert" ribbon at the top of the window. Then, click on the "Link" button, which may be represented as a chain link icon or simply labeled "Link" in the dropdown menu. This will allow you to add a hyperlink to a selected text or object in your presentation.
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.
Which button can you click to get the desired font to display?
To change the font display, look for the "Font" or "Text" button in your application's toolbar or formatting options. This button typically allows you to select different font styles, sizes, and colors. In word processors, it may be represented by a dropdown menu or an icon that resembles a capital "A." Click on it to access the font settings you need.
How do you change the resolution of a HP thin client?
To change the resolution of an HP thin client, right-click on the desktop and select "Display Settings." From there, you can adjust the screen resolution by selecting your desired resolution from the dropdown menu. After making your selection, click "Apply" to save the changes. If needed, you may also adjust other display settings such as orientation or scaling.
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.
