!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 the value in the same column from a row you specify!is the value to be found in the first row 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 looked up. Table_array can be a reference to a range or a range name!is the row number in table_array from which the matching value should be returned. The first row of values in the table is row 1!is a logical value: to find the closest match in the top row (sorted in ascending order) = TRUE or omitted; find an exact match = FALSE!
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 ...
Macros are disabled because the security level is set to Very High. To run the macros, change the security level to a lower ...