Press F4 three times C2 will change to C2. Looks for a value in the leftmost column of a table and then returns a value in the same row from a column you specify. See the full explanation of VLOOKUP Basically you define a value the lookup_value for the formula to look for.
Press F4 two times C2 will change to C2.
Press F4 two times C2 will change to C2. Shortcut to add Sign to Cell References. To decrease a number by a percentage simply change the plus sign to a minus sign. After giving the cell reference to cell A2 press the F4 key and see the magic.