How To Use VLOOKUP in Excel - 11 12. Click OK Note how Excel translated the formula to "Democratic" 13. If you plan to copy this formula to other cells, you need to make an adjustment. Click the Insert Function button again. Note: You can make edits using the formula bar, but if you're just starting out, I find it easier to use the dialog box. = MATCH (lookup_value_1 & lookup_value_2, lookup_array_1 & lookup_array_2, match_type) It's very important to note that when you use an array formula like this one, you'll need to commit your formula using Ctrl+Shift+Enter rather than just pressing Enter. This will tell Excel that you're using an array formula rather than a standard formula. 1. Click the cell where you want to enter the function. 2. Type = (equal sign), enter the name of the function, and then type an opening parenthesis. 3. Click the tab for the first worksheet that you want to reference. 4. Hold down Shift and click the tab for the last worksheet that you want to reference. 5. To indicate that a drop down list is present, Excel displays a down arrow to the right of the cell. Create A Drop Down List From A Range Of Cells To create a drop down list from the contents of a range of cells, first of all type in the values you want to appear in the list in a single row or single column in your workbook. If you send your Excel file to someone using a different language for Excel than you, the functions and formulas used in the workbook are automatically translated by Excel when opening the file. However, the automatic translation usually does not work, if you directly insert foreign language formulas into your worksheet.