Microsoft Office Tutorials and References
In Depth Information
Examples of Lookup and Reference Functions
4 For a logical type
116 For an error type
664 An array type
Figure 12.20 shows the results for various values in the TYPE function.
Figure 12.20.
Figure 12.20. The
The TYPE
TYPE function returns what type of value is specified as
function returns what type of value is specified as
an argument.
an argument.
Examples of Lookup and Reference Functions
The Lookup & Reference icon contains 18 functions. The all-star of this
group is the venerable VLOOKUP function, which is one of the most powerful
and most used functions in Excel. As database people point out, a lot of work
done in Excel should probably be done in Access. The VLOOKUP function en-
ables you to perform the equivalent of a join operation in a database.
This lookup and reference group also includes several functions that seem
useless when considered alone. However, when combined, they allow for some
very powerful manipulations of data. The examples in the following sections
Search JabSto ::




Custom Search