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,...)
Search JabSto ::




Custom Search