Microsoft Office Tutorials and References
In Depth Information
VLOOKUP
Figure 9.15
Be sure to select the
region of the destination
of the transposed table.
A
Select entire
destination when
transposing cells.
B
Ctrl+Shift+Enter to activate array.
Figure 9.16
The result of the
TRANSPOSE function
operating on a table.
Press Ctrl+Shft+Enter
instead of Enter to enter
the formula as an array
and fill the entire
highlighted range with the
new transposed data.
A
The result of
the transposed
table.
VLOOKUP
VLOOKUP looks for a value in the leftmost column of a table and returns a value from the
column number that you specify.
=VLOOKUP(lookup_value,table_array,column_index_num,range_lookup)
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.
Search JabSto ::




Custom Search