crystal reports 9 qr code Use the LOOKUP, HLOOKUP, VLOOKUP, INDEX, and MATCH Worksheet Functions in Font

Drawer DataMatrix in Font Use the LOOKUP, HLOOKUP, VLOOKUP, INDEX, and MATCH Worksheet Functions

In addition to the Find and Go To commands and the OFFSET function, you can also use the LOOKUP HLOOKUP VLOOKUP INDEX, and MATCH worksheet functions to find specific data , , , values:

Use the LOOKUP function to return a data value from a group of cells across a single row or down a single column. Use the HLOOKUP function to return a data value in a single column of a group of cells based on a matching data value in the first row of the group of cells and a row number in the matching data value s corresponding column. Use the VLOOKUP function to return a data value in a group of cells based on a matching data value in the first column of the group of cells and a column number in the matching data value s corresponding row. Use the INDEX function to return a data value in a group of cells based on the intersection of a row number and column number. Use the MATCH function to return the position of a data value in a group of cells.

The LOOKUP function returns a data value from a group of cells across a single row or down a column. The vector (a group of cells across a single row or down a single column) form of the LOOKUP function takes three arguments: lookup_value, lookup_vector, and result_vector: The required lookup_value argument is the data value that you want to find in the vector. The data value can be a number, a string of text characters, the data values False or True, or a cell reference that refers to a data value. The required lookup_vector argument is the reference to a group of cells across a single row or down a single column. The referenced cells can contain numbers, strings of text characters, or the values False or True. The values must appear in ascending order.

s Note If the LOOKUP function can t find the data value specified in the lookup_value argument, it matches

the largest value in the lookup_vector argument that is less than or equal to the data value specified in the lookup_value argument. If the data value specified in the lookup_value argument is smaller than the smallest data value specified in the lookup_vector argument, the LOOKUP function returns the #N/A error value.

The required result_vector argument is a corresponding group of cells across a single row or down a single column. This group of cells must have the same number of cells as the cells referenced in the lookup_vector argument.

s There is another version of the LOOKUP function called the array form of the LOOKUP function, but Tip using the HLOOKUP or VLOOKUP functions (described next) is generally preferred over using the array form of the LOOKUP function.

The HLOOKUP function returns a data value in a single column of a group of cells based on a matching data value in the first row of the group of cells and a row number in the matching data value s corresponding column. The HLOOKUP function takes four arguments: lookup_value, table_array, row_index_num, and range_lookup: The required lookup_value argument specifies the data value to be found in the cell group s first row. The data value can be a number, a cell reference, or a string of text characters.

s Note If the value specified in the lookup_value argument is smaller than the smallest value in the first

The required table_array argument is a reference to a group of cells, by using either a cell reference or a reference to a named range. The data values in the first row of the group of cells must be numbers, strings of text characters, or the values False or True. The required row_index_num argument is the row number in the group of cells from which the matching data value will be returned.