VLookups, auto-filled cells, and drop boxes I need assistance writing a formula
ID: 3565567 • Letter: V
Question
VLookups, auto-filled cells, and drop boxes
I need assistance writing a formula that will auto-populate specified data in cell 2 based on data manually entered in cell 1. I have titled the first worksheet "New Loss" and the second worksheet "Values." The Values worksheet contains the specified data (under description) that I want auto-populated in cell 2.
I also would like for cell 3 to auto-populate the corresponding names when letters are typed. The list of names is also found on the Values worksheet. I believe this would be a drop down box function but am not sure.
Is there a way to eliminate my name from the comments?
See illustrations.
Lastly when the workbook is open, I would like it to view the same as Word document. Under View menu, selecting Page Layout is almost how I would like it to look but w/out any other pages, i.e. the blank 2nd page to the right in the illustration below.
Explanation / Answer
Right-click a toolbar and select Control ToolBox;
On the Control ToolBox toolbar, click the ComboBox icon;
Depress the left mouse button and draw the ComboBox on the worksheet;
Depress the left mouse button and drag the ComboBox to the desired position;
Re-size the ComboBox using the ComboBox's drag handles;
Right-click the ComboBox and select Properties to open the properties window;
Set the ListFillRange and MatchEntry properties as described in my previous response;
Close the Properties window;
Click the top left green icon on the Control Toolbox toolbar to exit design mode;
Close the Control Toolbox toolbar.
Your ComboBox should now be positioned where you want it and it should be loaded with the data in the range D2:D28 on the Values sheet. As you type each letter into the ComboBox you will observe the desired drill-down suggestion behaviour.
I assure you that the whole process is painless and it is much simpler and quicker to perform than to describe!
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.