i know this is a long shot to get a reply but figured what the hell. However, my code below is not working, it ru. My range of values for the drop-down should come from Range(A1:A5) in Sheet2 and Range(C1:C7) in Sheet2. I am struggling just trying to explain this so searching google has been frustrating. I want to create a drop-down list in Cell E5. 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. “so if i pick countersink in cell A2 from the list, the formula attached is main1B2*20+15. all the formulas are linked to the number you input in B2 on the main tab. so when i pick the item from the drop down, it pulls the formula. What are we looking for From which list are we doing a lookup on From which column do we want to retrieve the value Do we want an exact match Make sure. 2.Create a second sheet by clicking on the + sign near the bottom left-corner in Excel. each item in the list is linked to a formula. In the Data Validation window select List from the Allow dropdown, check the In-cell dropdown checkbox and in the source textbox enter your table. I have a drop down list in column A2-A13. i do have a pretty direct question that i am struggling to find help with. Hello, i really enjoyed this and it will be very helpful as i navigate through excel.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |