When you start typing a function name, Excel lists the functions that match. Press Tab to accept the highlighted one, and Excel writes the name and the opening parenthesis for you, so =VL and Tab gives =VLOOKUP(. Use the arrow keys to pick another suggestion first.