Extracts a single value from a column in a list or database that matches conditions you specify. For more information and examples, click . Database is the range of cells that make up the list or database. A database is a list of related data in which rows of related information are records and columns of data are fields. The first row of the list contains labels for each column.
Field indicates which column is used in the function.
Criteria is the range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label for specifying a condition for the column. The name by which you'll be known in the forums. Click Here to find out why. Selling and recruiting forbidden.