lookup_value,lookup_array,match_type!Returns the relative position of an item in an array that matches a specified value ...

!lookup_value,lookup_array,match_type!!Returns the relative position of an item in an array that matches a specified value in a specified order!is the value you use to find the value you want in the array, a number, text, or logical value, or a reference to one of these!is a contiguous range of cells containing possible lookup values, an array of values, or a reference to an array!is a number 1, 0, or -1 indicating which value to return.!

Locking objects has no effect unless the sheet is protected. To help protect the sheet, choose Format on the Home tab, and ... 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 ...