![]() ![]() i know this is a long shot to get a reply but figured what the hell. I am struggling just trying to explain this so searching google has been frustrating. this works great to provide an answer in C2, but when i pick something from the list in A3-A13, it still pulls the formula but still links it to the number inputted in B2 instead of finding the corresponding “B column” that matches the item picked in the “A” column. ![]() To achieve this, right click on the sheet tab of Sheet2 and click on Hide. Note: if you dont want users to access the items on Sheet2, you can hide Sheet2. On the second sheet, type the items you want to appear in the drop-down list. “so if i pick countersink in cell A2 from the list, the formula attached is main1B2*20+15. To create a drop-down list in Excel, execute the following steps. In the Source: box, enter in your values separated by commas. In the Allow: dropdown menu, select List. Click on the Data Validation menu (in the Data tab in the Excel Ribbon), or use the shortcut Alt-A-V-V. all the formulas are linked to the number you input in B2 on the main tab. In your Excel workbook, select the cells that you want to apply the drop down menu to. so when i pick the item from the drop down, it pulls the formula. each item in the list is linked to a formula. I have a drop down list in column A2-A13. Then select Data from the menu, and select Data Validation in the ribbon. ![]() Back on the first sheet, select the blank cell to the right of the first label. i do have a pretty direct question that i am struggling to find help with. Now it’s time to set up your multiple, linked drop-down lists. Type in Yes, No as the Source for the drop-down. Hello, i really enjoyed this and it will be very helpful as i navigate through excel. In the Settings tab, select List under Allow, and ensure that Ignore blank and In-cell dropdown are checked. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |