You realize you are using the right document editor when such a simple task as Assign dropdown permit does not take more time than it should. Editing files is now an integral part of numerous working operations in different professional areas, which is why convenience and simplicity are essential for editing resources. If you find yourself researching manuals or searching for tips about how to Assign dropdown permit, you might want to get a more intuitive solution to save time on theoretical learning. And this is where DocHub shines. No training is required. Simply open the editor, which will guide you through its main functions and features.
A workflow gets smoother with DocHub. Use this instrument to complete the documents you need in short time and take your productivity to the next level!
To add a drop-down list of companies that auto-populate totals, go to the data tab, select all companies, give them a named range (e.g., "company"), return to sheet 1, set data validation to allow lists with "equals companies," use the formula "=VLOOKUP(lookup value, table array, column index, exact match)", and select the total column (column 2).