Discuss the use of a VLOOKUP (or HLOOKUP) and compare it to nesting IF statements. What are the considerations concerning the data? When is one preferred over the other? What is the purpose of the range lookup parameter? VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])