Click into the Lookup_Value box and then click on cell B2. While your formula reads =C2*, you can open the Name Box and choose VLOOKUP from the recently used functions or click More Functions and type VLOOKUP.Įxcel will open the Function Arguments dialog for the VLOOKUP function. When you are in the middle of editing a formula, opening the Name Box provides a list of the 10 formula functions you have used most recently. The Name Box is a dropdown menu that appears to the left of the formula bar.
The VLOOKUP is going to look for the current month’s data by using the MATCH, TODAY, and TEXT functions.
Let’s say that you need to multiply cell C2 by the result of a VLOOKUP function. It isn’t intuitive, but you can successfully use the Function Arguments dialog for each of the functions in the formula. Keyboard shortcut fans might know that you can start typing a formula, like =VLOOKUP(, into a cell and then press Ctrl+A to open the Functions Argument for that function.įrequently when using Excel, though, you might need to create formulas that nest one function inside of another function-for example, like when you have to put a MATCH function inside of an INDEX or VLOOKUP function. Normally, you would open the Functions Argument dialog by clicking the fx icon (known as Insert Function) located on the Formulas tab of the ribbon and also to the left of the Formula Bar.
