The Excel / Google Sheet formula VLOOPKUP is our friend! That's how it works: A Get the flag codes table. So all cells except for the first column (for the name) and the first row (for the header info). Click OK to close and see how the data of the Excel file is copied into this table.If you just want to create a form for a one-time use, click in any cell of your range or table and click Alt+D+O (or, if you hold down the Alt key, Alt+D+O+O). Even though creating a data-entry form is not part of the default ribbon, it is easy to create one.
