lookup_value,table_array,col_index_num,range_lookup!Looks for a value in the leftmost column of a table, and then returns ...

!lookup_value,table_array,col_index_num,range_lookup!!Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify. By default, the table must be sorted in an ascending order!is the value to be found in the first column of the table, and can be a value, a reference, or a text string!is a table of text, numbers, or logical values, in which data is retrieved. Table_array can be a reference to a range or a range name!is the column number in table_array from which the matching value should be returned. The first column of values in the table is column 1!is a logical value: to find the closest match in the first column (sorted in ascending order) = TRUE or omitted; find an exact match = FALSE!

logical1,logical2,.!Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE!are 1 to 255 conditions ... logical1,logical2,.!Checks whether any of the arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all arguments ... logical_test,value_if_true,value_if_false!logical_test!Checks whether a condition is met, and returns one value if TRUE, ... lookup_value,lookup_array,match_type!Returns the relative position of an item in an array that matches a specified value ... lookup_value,table_array,col_index_num,range_lookup!Looks for a value in the leftmost column of a table, and then returns ... lookup_value,table_array,row_index_num,range_lookup!Looks for a value in the top row of a table or array of values and returns ... lower_limit,upper_limit!Returns the error function!is the lower bound for integrating ERF!is the upper bound for integrating ... Macro-enabled file extensions (|) cannot be used with macro-free files. Change the file extension in the File Name text box ... Macros are disabled because the security level is set to High and a digitally signed Trusted Certificate is not attached ...