Microsoft Office Tutorials and References

In Depth Information

**HLOOKUP and VLOOKUP**

=NOW()

=TODAY()

HLOOKUP and VLOOKUP

HLOOKUP and VLOOKUP both find a value in a table. A
table
is an area of

rows and columns that you define. Both of these functions work by using a

search value for the first argument that, when found in the table, helps return

a different value.

In particular, you use HLOOKUP to return a value in a row that is in the same

column as the search value. You use VLOOKUP to return a value in a column

that is in the same row as the search value. The syntax for these functions

follows:

=HLOOKUP(lookup value, table area, row, match type)

=VLOOKUP(lookup value, table area, column, match type)

ISNUMBER

A rose is a rose and by any other name would smell as sweet, but numbers

donâ€™t get off that easy. For example, 15 is a digit, but fifteen is a word. The

ISNUMBER function tells you, flat-out true or false, if a value in a cell is a

number (including the results of formulas). The syntax follows:

=ISNUMBER(value)

MIN and MAX

MIN and MAX find the respective lowest or highest numeric value in a range

of values. These functions take up to 255 arguments, and an argument can be

a range. Therefore, you can test a large list of numbers simply by entering the

list as a range. The syntax for these functions follows:

=MAX(number1,number2,...)

=MIN(number1,number2,...)