Microsoft Office Tutorials and References
In Depth Information
Be sure to select the
region of the destination
of the transposed table.
Ctrl+Shift+Enter to activate array.
The result of the
operating on a table.
instead of Enter to enter
the formula as an array
and fill the entire
highlighted range with the
new transposed data.
The result of
VLOOKUP looks for a value in the leftmost column of a table and returns a value from the
column number that you specify.
The VLOOKUP is one of those functions that has multiple purposes, and is useful in just about ever y
walk of business life. If you have employee time sheets on a weekly or daily basis, this is a good
formula to use when looking up the rate for the employee and matching it to the name of the
employee in the list. Notice the example in Figure 9.17: =VLOOKUP(F6,$C$6:$D$8,2,false)
produces the rate of the employee from the rate table. In this example, F6 is the lookup value of
the employee’s name, C6:D8 is the rate table referenced, and 2 is the column index number from
the rate table in which you want a value return. The range lookup is what Excel uses as a result.